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

4 votes60 views1 answer
And or sql order of operations
SQL
0 vote104 views1 answer
Authentication modes in sql server
SQL
0 vote105 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote197 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote109 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote174 views1 answer
Mysql select field if condition
SQL
1 vote99 views1 answer
Select count distinct multiple columns sql server
SQL
2 votes103 views1 answer
Rails execute sql
SQL
1 vote97 views1 answer
Mysql show current queries
SQL
11 votes106 views1 answer
Mysql text type max length
SQL