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 vote187 views5 answers
Spring boot sql logging
SQL
0 vote194 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
-1 vote180 views1 answer
Plsql while
SQL
6 votes185 views1 answer
Oracle trigger after logon on database
SQL
0 vote218 views1 answer
.sql File Run in PSQL
SQL
0 vote219 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote230 views1 answer
Postgres power
SQL
0 vote200 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote215 views1 answer
How to combine first and last nae into one columb sql
SQL
1 vote201 views1 answer
Altrer name column postgres
SQL