create table t_newtable as (select *from t_oldtable); 只拷贝表结构 create table t_newtable like t_oldtable;