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 vote149 views2 answers
Sql for date greater than
SQL
1 vote179 views2 answers
Mysql does sentance contain word
SQL
2 votes148 views1 answer
Mysql query unique column
SQL
1 vote150 views1 answer
Show table columns
SQL
0 vote156 views1 answer
How to install mysql without admin rights
SQL
0 vote146 views1 answer
Select all tables linked server sql
SQL
0 vote156 views1 answer
Sql reverse order of results
SQL
1 vote156 views1 answer
Sometimes i cant edit sql developer
SQL
1 vote178 views1 answer
Mysql update inner
SQL
0 vote155 views1 answer
Sql query contains multiple ids
SQL