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

57 votes492 views5 answers
How to create a new user in postgresql
SQL
0 vote282 views1 answer
Oracle show running job
SQL
0 vote281 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote287 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote318 views1 answer
Sqlalchemy _in array sqlite
SQL
5 votes297 views2 answers
Postgresql insert select
SQL
0 vote278 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote277 views1 answer
Min and max salary and name in sql
SQL
18 votes245 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote288 views1 answer
Select odd records sql
SQL