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

2 votes359 views1 answer
Sql OR
SQL
3 votes429 views1 answer
Apex call duration
SQL
4 votes366 views3 answers
Rename table column postgresql
SQL
3 votes338 views2 answers
Pl sql escape '
SQL
0 vote354 views1 answer
Db format in quotation
SQL
6 votes382 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote396 views1 answer
Oracle create program if not exists
SQL
1 vote382 views1 answer
Mysql last year
SQL
1 vote344 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote388 views1 answer
Add super privilege mysql
SQL