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 vote223 views1 answer
Turn on foreign keys check mysql
SQL
0 vote201 views1 answer
Mssql + bit + in python orm
SQL
2 votes175 views3 answers
Postgres remove foreign key constraint
SQL
0 vote187 views1 answer
Mysql coonect sample code
SQL
0 vote214 views1 answer
Print intervals of 15 minutes in sql query
SQL
1 vote189 views1 answer
Mysql history command
SQL
0 vote154 views1 answer
Login phpmyadmin without password
SQL
5 votes194 views2 answers
Ranking functions in sql
SQL
1 vote254 views2 answers
Intersect sql
SQL
0 vote178 views1 answer
Wordpress database query change url
SQL