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 vote137 views1 answer
Get clob size oracle
SQL
0 vote140 views1 answer
Utiliser sql ligne de commande
SQL
0 vote130 views1 answer
Report in database
SQL
1 vote137 views1 answer
Increasing font and zooming in mysql workbench
SQL
2 votes124 views1 answer
Wait delay in sql server
SQL
6 votes136 views2 answers
Mysql set primary key
SQL
0 vote97 views1 answer
Como leer datos de mysql esp32
SQL
0 vote158 views2 answers
PostgreSQL having
SQL
0 vote133 views1 answer
Opensuse status MySQL
SQL
1 vote129 views1 answer
Check constraint to check if date greater than todays date
SQL