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

6 votes169 views1 answer
What is where clause in sql
SQL
0 vote161 views1 answer
Postgresql alter column nullable
SQL
0 vote192 views1 answer
Connect laravel to mysql on mac
SQL
17 votes162 views4 answers
Sort by mysql
SQL
5 votes197 views3 answers
Select tables from mysql database
SQL
0 vote162 views3 answers
Joins and views sql
SQL
0 vote159 views2 answers
Show slave status mysql
SQL
0 vote169 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote198 views1 answer
Create a plsql object
SQL
3 votes172 views1 answer
DB: in eloquent using sql
SQL