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

2 votes321 views1 answer
Postgresql drop primary key constraint
SQL
1 vote350 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote328 views1 answer
Windows services sql
SQL
0 vote361 views2 answers
Temp tables in sql server
SQL
13 votes344 views1 answer
Sql join 3 tables on id
SQL
0 vote308 views1 answer
Difference between cross apply and inner join
SQL
1 vote394 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote342 views1 answer
Sql delete from with relation
SQL
0 vote344 views2 answers
Oracle ora-00054 how to unlock
SQL
3 votes359 views2 answers
Laravel tosql with bindings
SQL