Loading lesson path
Concept visual
Start at both ends
statement is used to insert new records in a table. It is possible to write the INSERT INTO statement in two ways:
Specify both the column names and the values to be inserted:
table_name ( column1, column2, column3, ...) VALUES (
value1, value2, value3, ...);If you insert values for ALL the columns of the table, you can omit the column names. However, the order of the values must be in the same order as the columns in the table:
table_name VALUES (
value1, value2, value3, ...);Customers table used in the examples:
89
Formula
305 - 14th Ave. S. Suite 3B98128
90
21240
91