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 vote189 views1 answer
List in one column mysql
SQL
1 vote190 views1 answer
Return size of tables in mysql
SQL
0 vote171 views1 answer
Insert thai language sql server
SQL
17 votes255 views6 answers
MySQL ORDER BY
SQL
0 vote189 views1 answer
Heavy table in mysql
SQL
5 votes190 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote250 views1 answer
Postgres extract number from string
SQL
5 votes225 views1 answer
Oracle add time to date
SQL
1 vote189 views1 answer
Get all db sizes in mysql server
SQL
3 votes217 views2 answers
Sql not contains
SQL