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 vote166 views1 answer
Truncate left characters mysql
SQL
16 votes175 views4 answers
Sort by sql
SQL
-2 votes204 views3 answers
How to fetch first 10 rows in sql
SQL
2 votes174 views2 answers
Checking data type in sql server
SQL
0 vote166 views2 answers
Sql if empty then
SQL
6 votes179 views3 answers
Mysql remove user privileges
SQL
0 vote172 views1 answer
Replace null value within column mysql
SQL
0 vote173 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote181 views1 answer
Laravel migration sql dump
SQL
0 vote178 views1 answer
Postgres copy command
SQL