The SQL SELECT INTO statement can be used to create backup copies of tables.
The SELECT INTO statement selects data from one table and inserts it into a different table.
The SELECT INTO statement is most often used to create backup copies of tables.
We can select all columns into the new table:
Or we can select only the columns we want into the new table:
Make a Backup Copy - Now we want to make an exact copy of the data in our "Persons"
We use the following SQL statement:
We can also use the IN clause to copy the table into another database:
We can also copy only a few fields into the new table:
We can also add a WHERE clause.
The Below SQL statement creates a "Persons_Backup" table with only the persons who
lives in the city "New Orleans":
Selecting data from more than one table is also possible.
The Below example creates a "Persons_Order_Backup" table contains data from the two
tables "Persons" and "Purchases":
Your Query was successfully sent!