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 vote128 views2 answers
Sql where is not number
SQL
6 votes106 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote108 views1 answer
Doesn't have default value mysql
SQL
1 vote118 views2 answers
How to check if sql query is correct online
SQL
0 vote117 views1 answer
Query archive mode
SQL
1 vote124 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote118 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
1 vote74 views2 answers
Get date from datetime postgresql
SQL
0 vote116 views1 answer
Get first monday of month sql
SQL
0 vote123 views1 answer
Mysql convert charset
SQL