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

2 votes184 views2 answers
Run mysql command from bash
SQL
1 vote181 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote203 views1 answer
Order child below the parent in mysqli
SQL
1 vote181 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote183 views1 answer
Groupby sort sql hive
SQL
0 vote180 views2 answers
How to update the multiple rows in sql
SQL
0 vote181 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote169 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
14 votes172 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
1 vote181 views1 answer
Mysql select row with max value group by
SQL