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 vote167 views2 answers
How to drop mili second in sql
SQL
1 vote165 views1 answer
Apex select list ORA-20999
SQL
0 vote188 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote143 views1 answer
Fix sqlite3 ruby on rails
SQL
0 vote157 views1 answer
Sql values not in another table
SQL
1 vote226 views1 answer
Concat first name and last name in mysql
SQL
15 votes146 views1 answer
Mysql int range
SQL
0 vote143 views2 answers
How to update date in oracle
SQL
0 vote152 views1 answer
Linebreak sql
SQL
0 vote151 views2 answers
What is 1=2 in sql
SQL