- --只复制表结构
- create table studentTemp as select * from student where 1=2;--条件为假 未得到数据
- --复制已有表数据到新表
- insert into studentTemp select * from student;
- insert into studentTemp(...) select ... from student;
- --复制表结构与数据
- create table copyStudent as select * from student;
- insert into copyStudent select * from student;
- --该片段来自于http://www.codesnippet.cn/detail/190820135196.html
来源: http://www.codesnippet.cn/detail/190820135196.html