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 vote202 views1 answer
Sql anywhere create procedure
SQL
1 vote209 views1 answer
Postgres install unaccent extension
SQL
1 vote226 views1 answer
Select users with same username
SQL
21 votes210 views5 answers
Oracle all tables
SQL
2 votes196 views1 answer
Mysql sysdate
SQL
0 vote197 views1 answer
TSQL function split string
SQL
1 vote385 views1 answer
Athena query timestamp greater than
SQL
0 vote197 views1 answer
Drop domain postgresql
SQL
0 vote219 views1 answer
Store case result sql
SQL
0 vote209 views2 answers
Select index table oracle
SQL