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 vote344 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote310 views1 answer
Postgresql where clause not working
SQL
0 vote334 views1 answer
How to make case insensitive in sql
SQL
9 votes348 views2 answers
Nosql databases
SQL
0 vote353 views1 answer
Sql server synonym
SQL
7 votes358 views1 answer
Show line number in sql server
SQL
3 votes323 views3 answers
Create a view postgres
SQL
0 vote364 views1 answer
Sql show founctions
SQL
0 vote324 views1 answer
Frename oracle
SQL
3 votes302 views1 answer
Mysql load sql from file
SQL