Copy table in sql

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

Copy table in sql

CREATE TABLE employees_copy
 AS 
 SELECT first_name, last_name, email FROM employees WHERE 1=0;

Source: rebellionrider.com

Similar codes

3 votes106 views2 answers
Oracle grants
SQL
2 votes62 views4 answers
Mysql change database character set to utf8mb4
SQL
1 vote117 views2 answers
Sql server concat string and int
SQL
1 vote106 views1 answer
Wherein mysql
SQL
0 vote120 views1 answer
Ms sql filter all sympbol
SQL
6 votes122 views2 answers
Difference between join vs union
SQL
17 votes136 views6 answers
Sql current date
SQL
3 votes107 views1 answer
Oracle sleep
SQL
0 vote184 views1 answer
Sql if clause within where clause
SQL
12 votes125 views6 answers
Change mysql root password
SQL