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 votes122 views2 answers
Insert all in sql
SQL
1 vote137 views1 answer
Sql in array query
SQL
0 vote131 views3 answers
Run sql command line
SQL
3 votes119 views1 answer
Select nextval from sequence sql
SQL
0 vote178 views1 answer
Alter table name including schema
SQL
0 vote124 views1 answer
Oracle cpu metric
SQL
0 vote113 views1 answer
Postgresql create table default value timestamp
SQL
0 vote150 views1 answer
How to get table id sequence postgres
SQL
1 vote153 views1 answer
Insert many to many sql
SQL
1 vote110 views1 answer
Error code 1055
SQL