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 votes332 views1 answer
Columns Present in a table
SQL
1 vote428 views2 answers
Begin transaction sql
SQL
-1 vote364 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote339 views2 answers
Update all columns in one update
SQL
0 vote329 views1 answer
Sql offfset
SQL
5 votes333 views1 answer
Sql check if date is between 2 dates
SQL
0 vote355 views1 answer
Oracle cpu metric
SQL
47 votes400 views6 answers
Add column mysql
SQL
1 vote320 views2 answers
Pl sql case
SQL
0 vote347 views1 answer
Enable sql server full text indexing
SQL