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

Into sql

-- INTO copies specified columns into a new table
SELECT *
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

SELECT column1, column2, column3
INTO newtable [IN externaldb]
FROM oldtable
WHERE condition;

Eg: SELECT * INTO CustomersBackup
	FROM Customers;
    
    SELECT * INTO CustomersBackup IN 'Backup.mdb'
	FROM Customers;
    
    SELECT CustomerName, ContactName INTO CustomersBackup2017
	FROM Customers;

Similar codes

3 votes303 views2 answers
Mysql import gz
SQL
0 vote286 views2 answers
Android sqlite tutorial for beginners
SQL
14 votes324 views3 answers
How to add default constraint in mysql
SQL
1 vote313 views1 answer
Store select query result in variable sql server
SQL
0 vote290 views1 answer
Increase speed of like queries postgres
SQL
0 vote287 views1 answer
Check if table exists oracle
SQL
0 vote298 views3 answers
Insert query in ci
SQL
0 vote292 views1 answer
Oracle procedure teamplate
SQL
0 vote296 views1 answer
Vbscript clean up ADODB.Recordset
SQL
3 votes297 views1 answer
Select database in sql
SQL