MySQL INSERT Statement Variations

“The Data Manipulation Language (DML) SELECT…INTO command is
unsupported in MySQL. However, MySQL does provide the
INSERT…SELECT statement. Rob Gravelle discusses this, and other
variations of the INSERT statement.

“In the MySQL Data Manipulation and Query Statements article, we
looked at two variations of the INSERT INTO statement. If you
recall, we utilized the INSERT statement to populate tables, rather
than the Data Manipulation Language (DML) SELECT…INTO command,
which is unsupported in MySQL. However, MySQL does provide the
INSERT…SELECT statement. This, and other variations of the INSERT
statement will be the topic of today’s article.

“Inserting Multiple Rows The INSERT INTO syntax that we used
came in two forms – one with column names and one in which
they were omitted:

Complete Story