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 vote358 views1 answer
Login to database mysql terminal
SQL
61 votes527 views6 answers
Mysql add column
SQL
8 votes353 views1 answer
Oracle current date plus 1 month
SQL
0 vote359 views1 answer
Sql out file formate
SQL
1 vote349 views1 answer
Postgresql substring last
SQL
2 votes348 views2 answers
Spring import sql
SQL
0 vote332 views1 answer
Sql examples from framework
SQL
0 vote314 views1 answer
Flask sqlalchemy update row
SQL
0 vote309 views1 answer
Restore backup "text" postgresql command line
SQL
11 votes344 views3 answers
Sql line numbers
SQL