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

0 vote178 views2 answers
Find Overlapping sql
SQL
0 vote187 views1 answer
How to reset the database value in SQL server
SQL
4 votes319 views1 answer
What are the data types
SQL
0 vote216 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
2 votes185 views1 answer
Sql ignore accents
SQL
2 votes198 views2 answers
Mysql alter column default
SQL
5 votes214 views3 answers
Select tables from mysql database
SQL
0 vote155 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
2 votes176 views1 answer
Oracle sql query to make column data uppercase
SQL
1 vote188 views2 answers
Mysql: command not found
SQL