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 vote257 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote253 views1 answer
Truncate table sql server foreign key
SQL
2 votes269 views1 answer
Compare date in sql
SQL
0 vote289 views1 answer
Sql: extract day text from datetime value
SQL
1 vote302 views1 answer
Concat first name and last name in mysql
SQL
0 vote274 views1 answer
Selecting duplicates
SQL
0 vote294 views1 answer
Mysql where sum > 0
SQL
0 vote278 views1 answer
Sql drop procedure if exists
SQL
0 vote267 views1 answer
Oracle temporary table
SQL
0 vote307 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL