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 vote155 views1 answer
Sql declare variable single line
SQL
1 vote126 views3 answers
What is union in sql
SQL
0 vote123 views1 answer
Mysql database hyphen
SQL
0 vote156 views1 answer
Gcloud sql instance list
SQL
1 vote121 views1 answer
Oracle apex run 404
SQL
6 votes141 views2 answers
What is non relational database
SQL
5 votes139 views2 answers
Postgresql insert select
SQL
0 vote114 views1 answer
Mysql select where text contains
SQL
6 votes138 views2 answers
Sql sequence
SQL
7 votes143 views1 answer
Sql limit decimal places
SQL