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 vote125 views1 answer
MySql count occurences more than"
SQL
23 votes115 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote142 views1 answer
Increase existing date in sql oracle
SQL
0 vote138 views1 answer
Normalization in database
SQL
0 vote135 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote154 views1 answer
Login failed for user sql server
SQL
0 vote82 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote124 views1 answer
Max length found in mysql
SQL
3 votes121 views3 answers
Print in pl sql
SQL
0 vote142 views1 answer
Shows all databases created by user in ms sql
SQL