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

1 vote144 views1 answer
Where not in array sql
SQL
1 vote129 views1 answer
Mysql batch insert
SQL
2 votes141 views1 answer
Sqlite show table indexes
SQL
0 vote152 views1 answer
Renommer schema sql
SQL
0 vote165 views1 answer
Sql get table last modified time
SQL
0 vote138 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote154 views1 answer
Sql server convert to guid
SQL
1 vote152 views2 answers
How to combine 2 tables in MySQL
SQL
15 votes143 views4 answers
Create table if not exists sql
SQL
0 vote136 views1 answer
Multiple left join mysql
SQL