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

0 vote114 views1 answer
What are the aggregate function in sql
SQL
11 votes157 views2 answers
Import sql file laravel cmd
SQL
34 votes147 views6 answers
Install mysql client ubuntu
SQL
0 vote127 views1 answer
Not equal to blank in mysql
SQL
0 vote129 views1 answer
Select * from mysql.proc
SQL
1 vote121 views1 answer
Mysql select row max date
SQL
28 votes88 views6 answers
Distinct sql
SQL
0 vote115 views1 answer
Limiting query result using where in sql
SQL
8 votes127 views3 answers
Connect python to mysql
SQL
0 vote126 views1 answer
Narural join
SQL