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 vote78 views1 answer
Copy table dbeaver
SQL
15 votes110 views7 answers
MYSQL
SQL
1 vote144 views1 answer
Concat first name and last name in mysql
SQL
11 votes134 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote75 views1 answer
'0000-00-00' for column '
SQL
0 vote79 views1 answer
Postgres delete where id in
SQL
1 vote123 views1 answer
How to print longest name in sql
SQL
0 vote123 views1 answer
Casterar postgres
SQL
1 vote112 views1 answer
Sql server reseed single table
SQL
0 vote118 views1 answer
Create table with timestamp mysql youtube
SQL