Inserting Data in Tables

Adding data to a table is accomplished through the INSERT INTO command. We have several different options to use for inserting data.

Inserting data into all columns

The syntax for inserting into all columns is:

INSERT INTO TableSchema.TableName
VALUES (ValueForColumn1, ValueForColumn2, ...);

Note: The order of values must be the same as the order of columns when the table was created.

Let’s consider a situation where we create a table with this command:

...