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

4 votes342 views1 answer
Oracle delete last row
SQL
0 vote366 views1 answer
Do you know sql
SQL
0 vote344 views1 answer
Search In the Data using ObjectName
SQL
18 votes377 views3 answers
Get the list of all tables in sql server
SQL
38 votes356 views4 answers
Count sql
SQL
0 vote327 views1 answer
Difference between cross apply and inner join
SQL
6 votes349 views5 answers
Alter table oracle
SQL
0 vote359 views1 answer
Mysql cli output to a file
SQL
0 vote360 views1 answer
Where date in datetime mysql
SQL
0 vote418 views1 answer
Mssql last day of month
SQL