Learn SQL Database Programming

Inserting data from one table into another table

When inserting from one table into another table, you have a couple of options:

• You can create a new table and insert data into it from an existing table
• You can insert data into an existing table from another table

If you want to create a new table and insert data into it from an existing table, use the following syntax:

CREATE TABLE newtablenameSELECT * FROM existingtablename

The previous query creates a new table and inserts the records from the SELECT statement on an existing table into the new table. This gives you a copy of all the data from the original table. The following query creates a new table named managerscopy and places all the data from the existing table, managers, into ...