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 vote149 views1 answer
Google sheets filter rows above current cell
SQL
1 vote148 views1 answer
Mysql text to decimal
SQL
0 vote168 views1 answer
Dual in db2
SQL
2 votes150 views1 answer
Mysql virtual column
SQL
1 vote155 views2 answers
Snowflake alter column data type
SQL
2 votes189 views1 answer
Select from array in psql
SQL
0 vote146 views1 answer
Mysql connection with sqlalchecmy
SQL
0 vote157 views1 answer
Sqlalchemy one column of two has to be not null
SQL
7 votes183 views1 answer
Oracle pagination query rownum
SQL
4 votes296 views2 answers
Sql display today's date
SQL