Multiple Insert Into a Table From Another Table

posted on December 13, 2010 10:41 AM by Jhoy Imperial
under MySQL, Tutorials
tagged mysql script

A query for transferring data from one table to another.


INSERT INTO table2  (field1,field2,field3)

SELECT col1, col2, col3 FROM table1 WHERE table1_field2 = 10

In this query, we want to transfer the data from table1 whose col2 fields are equal to 10.

Origin Table table1

Destination Table table2

field1	field2	field3

After the query, table2 would look something like this:

HTH

Be Sociable, Share!