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 vote301 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote268 views1 answer
Mysql percentage of total
SQL
2 votes313 views1 answer
Merge firstname and lastname in sql oracle
SQL
4 votes295 views1 answer
T-sql get duplicate rows
SQL
0 vote301 views1 answer
Sql count matching group by
SQL
0 vote318 views1 answer
Google sheets data validation custom formula filter
SQL
2 votes312 views2 answers
Postgres trigger insert into another table
SQL
0 vote289 views1 answer
Mysql jdbc timezone
SQL
7 votes298 views3 answers
Select latest entry in sql table
SQL
1 vote289 views4 answers
Postgres extract date from timestamp
SQL