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 vote242 views2 answers
Clauses in mysql
SQL
-1 vote248 views1 answer
Mysql faster insert
SQL
0 vote210 views1 answer
Difference between 2 query results sql server
SQL
0 vote217 views1 answer
Xampp increame mysql speed
SQL
0 vote252 views1 answer
Show all sequences postgres
SQL
3 votes223 views1 answer
Dbms_scheduler drop_job
SQL
1 vote232 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
0 vote213 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
1 vote226 views1 answer
Mysql get domain from url
SQL
0 vote226 views1 answer
Update and keep original value sql
SQL