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 vote152 views1 answer
The fetch keyword oracle
SQL
10 votes133 views2 answers
Tsql merge example
SQL
1 vote134 views1 answer
Oracle create program if no exists
SQL
31 votes159 views4 answers
Mysql grant execute
SQL
22 votes139 views3 answers
How to join three tables in sql using joins
SQL
1 vote139 views1 answer
Oracle grant on all tables in schema
SQL
1 vote133 views1 answer
Update foreign key value in mysql
SQL
0 vote151 views1 answer
Mysql root localhost run
SQL
0 vote155 views1 answer
Sql count total by foreign key
SQL
6 votes133 views2 answers
How to get yesterday date in mysql
SQL