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 vote260 views1 answer
Mysql identified by syntax error
SQL
1 vote261 views1 answer
Altering the column name in MySQL to have a default value
SQL
4 votes260 views1 answer
Oracle table statistics last analyzed
SQL
0 vote277 views1 answer
Psql list rules
SQL
0 vote276 views1 answer
What does leave do in mysql
SQL
1 vote235 views2 answers
Procedure pl/sql
SQL
0 vote261 views1 answer
Postgres where
SQL
0 vote271 views1 answer
Sql server information_schema temp tables
SQL
1 vote258 views2 answers
Mysql current user
SQL
15 votes264 views2 answers
Select Options
SQL