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

9 votes132 views4 answers
How to remove duplicate in sql
SQL
0 vote135 views1 answer
Sql datediff db2
SQL
8 votes105 views1 answer
Oracle current date plus 1 month
SQL
11 votes138 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote133 views1 answer
Backup a table in sql
SQL
1 vote134 views1 answer
Find logged in users mysql
SQL
0 vote141 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote129 views1 answer
What is logical database schema
SQL
1 vote148 views1 answer
SQL Integer devision
SQL
0 vote134 views1 answer
Create boolean column in MySQL with false as default value?
SQL