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

1 vote133 views1 answer
Restart identity postgresql
SQL
0 vote167 views1 answer
Sql count total by foreign key
SQL
1 vote186 views1 answer
Quit mysql
SQL
4 votes176 views2 answers
Convert utc to est sql
SQL
3 votes169 views1 answer
Oracle APEX elapsed time
SQL
1 vote171 views1 answer
Sqlite3 read only
SQL
14 votes186 views3 answers
Inner join sql oracle
SQL
1 vote158 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote152 views2 answers
Avg() sql
SQL
0 vote166 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL