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 vote240 views1 answer
Sql server port 1434
SQL
0 vote251 views1 answer
Sqlite trim
SQL
0 vote191 views0 answer
SQL
0 vote226 views1 answer
Delete double on SQL with multiple primary keys
SQL
0 vote263 views1 answer
Oracle plsql sleep
SQL
11 votes246 views2 answers
How to import mysql database command line
SQL
0 vote214 views1 answer
Sql random decimal
SQL
1 vote220 views2 answers
Pl sql case
SQL
0 vote244 views1 answer
Custom row number
SQL
0 vote261 views1 answer
Mysql get hour from datetime
SQL