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

12 votes147 views2 answers
Insert multiple rows from another table sql
SQL
6 votes135 views1 answer
Rank function in oracle with example
SQL
3 votes147 views1 answer
Sql server version query
SQL
0 vote139 views1 answer
What are the aggregate function in sql
SQL
1 vote162 views1 answer
Mysql workbench in ubuntu 14.04
SQL
2 votes145 views1 answer
Possgress drop if exists table
SQL
0 vote139 views1 answer
Myswql show full processlist
SQL
1 vote139 views1 answer
Moodle query item quiz
SQL
0 vote156 views1 answer
Make parameters nullable in sql server
SQL
6 votes143 views4 answers
How to remove unique key in mysql
SQL