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

7 votes157 views6 answers
Mysql group concat
SQL
7 votes139 views6 answers
Nth highest salary in sql
SQL
9 votes145 views3 answers
Sql delete where in
SQL
1 vote135 views2 answers
Sql server backup table
SQL
1 vote141 views1 answer
Oracle stop job
SQL
1 vote135 views2 answers
How to check username in mysql command line
SQL
16 votes148 views2 answers
Add column if not exists mysql
SQL
0 vote128 views1 answer
Count the table indatabase
SQL
0 vote146 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote171 views1 answer
Sql today at midnight
SQL