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 vote171 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote169 views1 answer
Flexible search query delete table
SQL
2 votes170 views1 answer
Oracle sql drop column if exists
SQL
1 vote150 views1 answer
Oracle lock user
SQL
0 vote180 views1 answer
Sqlserver now
SQL
4 votes178 views1 answer
Adding data to table in sql python
SQL
9 votes183 views2 answers
Sql server check table exists
SQL
-1 vote161 views1 answer
How to check table exists or not in postgresql
SQL
0 vote171 views2 answers
Starting mysql service from mac
SQL
0 vote163 views1 answer
Json_remove mysql
SQL