Copy the Content of one Table to Another

The content of one table can be copied to another table using the INSERT INTO command. For example:

INSERT INTO table1 SELECT * FROM table2

The select can also be conditional with the addition or the chosen fields to be copied over.

INSERT INTO table1 SELECT FirstName,LastName,City FROM table2

Or it may be extended further so that the new table is derived from the join of one or more tables with a where clause limiting those items copied over, for example:

INSERT INTO table1 SELECT FirstName,LastName,City
FROM table2
INNER JOIN table3 ON table2.City = table3.city
WHERE table2.year='2012'