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 vote151 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
1 vote157 views1 answer
Name of today sql
SQL
0 vote151 views1 answer
Sqlcmd no headers
SQL
0 vote169 views1 answer
Dataframe lambda elif
SQL
0 vote146 views1 answer
Sql change default collation to utf8
SQL
1 vote145 views1 answer
Primary key with prefix sql
SQL
0 vote164 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote176 views1 answer
Limit offset order by mysql
SQL
0 vote172 views1 answer
Mssql last day of month
SQL
12 votes162 views4 answers
How to check mysql version ubuntu
SQL