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 vote373 views1 answer
Mariadb cast to int
SQL
0 vote346 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote387 views3 answers
Constraint sql
SQL
0 vote327 views1 answer
Select count postgres double row count > 1
SQL
0 vote323 views1 answer
Sql select with apostrohpe
SQL
1 vote337 views1 answer
Select from describe sql
SQL
5 votes321 views1 answer
Update sql user password
SQL
0 vote349 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote323 views1 answer
Alter table fulltext
SQL
-2 votes342 views1 answer
Trunc in sql
SQL