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

2 votes201 views2 answers
Sqlalchemy return id after insert
SQL
1 vote184 views1 answer
How to get the date diff on once field in sql server
SQL
2 votes173 views1 answer
How to delete columns in sql
SQL
2 votes181 views1 answer
Anonymous block plsql
SQL
4 votes192 views1 answer
SQL find text in SP
SQL
0 vote185 views1 answer
Postgres data location
SQL
0 vote246 views1 answer
Sql select rows between 1000 and 2000
SQL
61 votes1.2K views6 answers
Mysql add column
SQL
0 vote145 views1 answer
Postgresql subquery
SQL
0 vote184 views2 answers
T sql null or empty string
SQL