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 vote276 views3 answers
Sql server get week dates from week number
SQL
0 vote317 views1 answer
How to change mysql root password in windows 10
SQL
0 vote287 views1 answer
Ms sql filter all sympbol
SQL
5 votes315 views2 answers
Add days in oracle sql
SQL
1 vote274 views1 answer
Apex select list ORA-20999
SQL
0 vote308 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote277 views1 answer
Big table in mysql
SQL
0 vote276 views1 answer
Postgresql find missing id
SQL
25 votes294 views6 answers
Import mysql database command line
SQL
3 votes268 views1 answer
Oracle apex message quit website
SQL