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

5 votes185 views1 answer
Oracle ora-00054 causes
SQL
1 vote201 views1 answer
Generate random data postgresql
SQL
0 vote194 views1 answer
Sql select random procentage from rows
SQL
0 vote184 views1 answer
Sql row number in result set
SQL
0 vote219 views1 answer
Alter domain sql
SQL
1 vote193 views1 answer
Sql headers delphi
SQL
0 vote200 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote207 views1 answer
Firebase sql
SQL
1 vote189 views1 answer
Postgres select as csv
SQL
0 vote224 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL