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 vote154 views1 answer
How to fetch highest score in minimum time using mysql
SQL
10 votes187 views2 answers
Sql merge statement
SQL
0 vote226 views1 answer
Postgresql show owner of database
SQL
0 vote211 views1 answer
Get id if is not equal in certain table
SQL
0 vote209 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
1 vote202 views1 answer
Flask sqlalchemy default value
SQL
20 votes189 views1 answer
Get all table name in sql through php
SQL
0 vote235 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
8 votes209 views1 answer
Oracle all_source package body
SQL
0 vote230 views2 answers
What is rownum in oracle
SQL