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

9 votes396 views2 answers
Convert data type in sql
SQL
0 vote357 views1 answer
Monthly Birthday SQL Query
SQL
0 vote408 views1 answer
Mysql create index lost connection
SQL
0 vote360 views1 answer
Mysql disable query caching
SQL
0 vote369 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote357 views1 answer
Group by sql not ordering issues
SQL
0 vote372 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote435 views1 answer
Add two days to current date in sql when creating tables
SQL
21 votes405 views6 answers
Update sql
SQL
0 vote376 views1 answer
Install mysql for fedora 34
SQL