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 vote107 views1 answer
Mysql export and import
SQL
0 vote127 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote105 views1 answer
Default column value in sql same as other column
SQL
16 votes129 views3 answers
Order by sql query
SQL
49 votes182 views6 answers
Get duplicate records in sql
SQL
0 vote112 views1 answer
Mysqlimport
SQL
0 vote108 views1 answer
Sql replace id with name from another table
SQL
0 vote133 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
1 vote124 views2 answers
Oracle leftmost characters
SQL
0 vote121 views1 answer
Sql query for login with email or username
SQL