复制表数据或表结构

--复制表结构但不复制表数据
create table copytest as select * from t_employee WHERE 1<>1;
SELECT * FROM copytest;
--复制表结构的同时复制数据
create table copytest2 as SELECT * FROM t_employee;
SELECT * FROM copytest2;
--复制指定列的表结构
create table copytest3 as SELECT e.employee_code,e.name FROM t_employee e WHERE 1<>1;
SELECT * FROM copytest3;
--复制表的指定列的表结构及表数据
create table copytest4 as select t.employee_code,t.name from t_employee t ;
SELECT * FROM copytest4;