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

2 votes242 views1 answer
Sql string starts with
SQL
0 vote159 views1 answer
Finish transaction sql
SQL
0 vote213 views1 answer
Connecting to my cloud sql server with c#
SQL
1 vote211 views1 answer
Create table tablename as select * from tablename
SQL
4 votes239 views1 answer
Sql select limit range
SQL
7 votes207 views2 answers
Show size database mysql
SQL
1 vote204 views3 answers
Mysql connection string
SQL
0 vote244 views1 answer
Snowflake drop column
SQL
0 vote213 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
1 vote205 views2 answers
Mysql update LAST_INSERT_ID()
SQL