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 vote360 views1 answer
Sqlite3 update select
SQL
2 votes368 views1 answer
Cast string to datetime mysql
SQL
2 votes352 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote365 views1 answer
The fetch keyword oracle
SQL
3 votes398 views2 answers
Synonym oracle
SQL
0 vote368 views1 answer
Sql select upcoming birthdays
SQL
0 vote383 views1 answer
How to install sql in anaconda
SQL
13 votes317 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
2 votes366 views2 answers
Postgres add column integer
SQL
0 vote372 views1 answer
Sql query to find percentage of null values in a table
SQL