Into operator in 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

0 vote354 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
6 votes362 views2 answers
Difference between join vs union
SQL
8 votes350 views3 answers
Connect python to mysql
SQL
0 vote348 views1 answer
Sparql if bound query
SQL
0 vote343 views1 answer
Sql server get date of previous sunday
SQL
0 vote364 views1 answer
Tinydb add table
SQL
0 vote350 views1 answer
Cast float mysql
SQL
0 vote326 views1 answer
Get first monday of month sql
SQL
5 votes319 views1 answer
Mysql select greater than yesterday
SQL
0 vote329 views1 answer
Mysql replication change database name
SQL