都是创建一个新表
create table newtest like test; insert into newtest select * from test;
create table as 与create table like 的区别
原文:https://www.cnblogs.com/wpcnblog/p/13710375.html