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

Source: grepper.com

Similar codes

0 vote183 views1 answer
View t-sql mail configuration
SQL
0 vote194 views1 answer
Sql sum if
SQL
0 vote191 views1 answer
Python list from sql
SQL
0 vote185 views1 answer
Mysql find foreign key references
SQL
0 vote276 views1 answer
Mysql extract day from date leading zero
SQL
0 vote162 views1 answer
Sqlalchemy existing database
SQL
1 vote213 views1 answer
Mysql change root mysql_native_password
SQL
0 vote202 views1 answer
Sql orcale i forgot what my name & password was
SQL
1 vote220 views1 answer
Get current date in pyspark sql
SQL
5 votes192 views1 answer
Sql add column after another
SQL