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

3 votes244 views1 answer
How to remove characters from string in mysql
SQL
1 vote253 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote253 views1 answer
Do you know sql
SQL
1 vote263 views1 answer
Print all records of table in mysql
SQL
0 vote258 views1 answer
Query to remove duplicate rows from a table
SQL
1 vote247 views1 answer
Sql server find tables referenced foreign key
SQL
0 vote256 views1 answer
How to output a different column name in mysql
SQL
0 vote300 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote263 views1 answer
Mysql root permission denied lost
SQL
10 votes254 views1 answer
Create table oracle
SQL