Into sql

#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. 
syntax->SELECT *
INTO new_table_name [IN externaldatabase]
FROM old_tablename 
///example///
SELECT *
INTO Persons_Backup
FROM Persons

Source: grepper.com

Similar codes

0 vote282 views0 answer
SQL
0 vote313 views1 answer
Mysql get only the field names in a table
SQL
7 votes284 views4 answers
How to reset the identity column in sql server
SQL
12 votes322 views2 answers
Insert multiple rows from another table sql
SQL
8 votes324 views1 answer
Oracle add auto_increment column to existing table
SQL
3 votes313 views4 answers
Order by desc postgres
SQL
0 vote308 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
4 votes323 views4 answers
Date less than in sql
SQL
22 votes305 views4 answers
Mysql reset auto increment id
SQL
5 votes300 views2 answers
Oracle timestamp to date
SQL