复制表结构和数据: create table emp2 as select * from emp; 复制表结构: create table emp2 as select * from emp where 1 = 2;