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 vote199 views1 answer
Java sql insert return id
SQL
0 vote212 views1 answer
Uncheck constraints and delete from table
SQL
1 vote249 views1 answer
Does insert into overwrite sql
SQL
1 vote202 views1 answer
Mysql count words
SQL
0 vote203 views1 answer
Mysql max number not returning correct value
SQL
0 vote197 views1 answer
Dump only data
SQL
1 vote212 views2 answers
Insert sqlite
SQL
0 vote241 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote206 views1 answer
Sql tabelle erstellen
SQL
0 vote185 views1 answer
Create date sql
SQL