Into sql

#The SELECT INTO statement selects data from one table and inserts it into a different table. 
#The SELECT INTO statement is most often used to create backup copies of tables. 
syntax->SELECT *
INTO new_table_name [IN externaldatabase]
FROM old_tablename 
///example///
SELECT *
INTO Persons_Backup
FROM Persons

Into 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 vote241 views1 answer
Insert overwrite table in mysql in nifi
SQL
0 vote250 views1 answer
To Create directory
SQL
-1 vote255 views1 answer
Sql show custom constraints
SQL
0 vote241 views1 answer
Postgres statistics
SQL
2 votes268 views3 answers
Xampp mysql database not starting
SQL
1 vote247 views1 answer
Oracle drop job if exists
SQL
0 vote238 views1 answer
How to select a row in sql
SQL
12 votes224 views1 answer
How to change the value of a table in sql
SQL
0 vote223 views1 answer
Find largest table in mysql database
SQL
3 votes250 views2 answers
Postgres download
SQL