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.
SQL SELECT INTO Syntax
We can select all columns into the new table:
SELECT * INTO new_table_name [IN externaldatabase] FROM old_tablename |
Or we can select only the columns we want into the new table:
SELECT column_name(s)
INTO new_table_name [IN externaldatabase]
FROM old_tablename
SELECT LastName,FirstName
INTO Persons_Backup
FROM Persons
0 comments:
Post a Comment