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 vote251 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
0 vote277 views1 answer
Sql select duplicates based on two columns
SQL
0 vote288 views1 answer
Sql max of two values
SQL
0 vote270 views2 answers
Auto increment column in mysql query results
SQL
5 votes277 views1 answer
Sysdate in oracle sql
SQL
0 vote294 views2 answers
Temp Space
SQL
0 vote271 views2 answers
Mysql on update current_timestamp
SQL
0 vote260 views1 answer
Sql cheetsheet
SQL
0 vote247 views1 answer
Automate mysql cli query
SQL
1 vote306 views1 answer
Oracle show execution plan
SQL