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 vote184 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote178 views1 answer
Find number of entries sql
SQL
0 vote182 views1 answer
Sql getdate minus 1 day without time
SQL
1 vote199 views1 answer
Mysql datetime with timezone offset
SQL
0 vote184 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote171 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote167 views1 answer
What is the essence of SQL?
SQL
0 vote186 views1 answer
SQL Server Enterprise
SQL
0 vote164 views1 answer
Postgresql conectar
SQL
0 vote175 views2 answers
Mysql get routine parameter list
SQL