1:依据已有表创建一个新表 create table student6 as select * from student where 1=2; 如果省略where 1=2;则新表不仅拥有已有表的结构,也拥有了已有表的数据。 2:依据已有表插入数据 insert into student6 select * from student;