Into in sql

SELECT INTO

	SELECT * INTO nome_da_tabela_que_estao_a_mexer_BKP
	FROM nome_da_tabela_que_estao_a_mexer

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 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 vote216 views3 answers
Insert query in ci
SQL
0 vote228 views1 answer
Sql select sum group by id laravel join
SQL
0 vote234 views1 answer
Mysql conf.d exampel
SQL
0 vote208 views1 answer
Mysql_num_fields in mysqli
SQL
15 votes229 views5 answers
Select all tables sql
SQL
23 votes219 views4 answers
Uninstall postgresql ubuntu
SQL
22 votes216 views3 answers
Remove all records from table mysql
SQL
10 votes226 views3 answers
Join multiple tables sql
SQL
0 vote208 views1 answer
Look at running processes redshift
SQL
0 vote201 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL