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 vote304 views1 answer
Sql order by timestamp
SQL
2 votes268 views1 answer
Sql select min value from multiple columns
SQL
3 votes265 views2 answers
Having in mysql
SQL
4 votes280 views4 answers
Update select mysql
SQL
0 vote291 views1 answer
Two inner joins sql
SQL
3 votes313 views1 answer
Start mysql server linux terminal
SQL
5 votes281 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote274 views1 answer
Left join in codeigniter query builder
SQL
0 vote295 views1 answer
Alter check command
SQL
0 vote292 views1 answer
Select from column mysql
SQL