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 vote194 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote185 views1 answer
Wordpress sql change site url
SQL
2 votes186 views1 answer
Sql server conection string
SQL
5 votes205 views4 answers
Mysql update column with value from another table
SQL
0 vote204 views2 answers
Mysql insert into multiple tables
SQL
0 vote211 views1 answer
Starting mysql shell lampp ubuntu
SQL
0 vote145 views1 answer
Sql select rows with simlar names
SQL
0 vote189 views1 answer
Get the First and Last Word from a String or Sentence
SQL
0 vote189 views1 answer
Mysql add comment to column
SQL
0 vote207 views1 answer
How to get data from 2 database
SQL