Sql Insert Into Statement

If the statement does not specify the order of the columns, the values are added beginning with the first column.  Alternatively, the columns could be specified, in any order, some or all. SQL INSERT INTO Syntax SQL INSERT INTO Examples INSERT INTO also allows multiple rows to be inserted at one time. Unlike the previous example, where a single row of data was inserted into the table, we can also use the SELECT statement to specify the data that we want to insert into the table, from another table.