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

5 votes103 views1 answer
Alter table add comment oracle
SQL
0 vote105 views2 answers
Return the number of records in a single table mysql
SQL
8 votes112 views1 answer
Show mysql user table
SQL
0 vote111 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote108 views1 answer
Create mysql pool connection python flask
SQL
1 vote108 views1 answer
Postgresql datetrunc too slow
SQL
11 votes103 views3 answers
Change column name sql server management studio
SQL
0 vote138 views2 answers
Sql unique
SQL
2 votes59 views1 answer
Sql select min value from multiple columns
SQL
0 vote101 views2 answers
Pop sql insert value into
SQL