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 vote332 views1 answer
Varchar2 length in oracle
SQL
0 vote317 views3 answers
Joins and views sql
SQL
0 vote312 views1 answer
Group by sql not ordering issues
SQL
0 vote336 views1 answer
Csv to sqlite python
SQL
5 votes308 views2 answers
Oracle show procedures
SQL
44 votes368 views6 answers
Rename command in sql
SQL
0 vote265 views1 answer
Finish transaction sql
SQL
24 votes325 views4 answers
Mysql datetime
SQL
5 votes286 views2 answers
Create table
SQL
5 votes291 views2 answers
Mysql where in array
SQL