1.
create table t1 select * from user
注：t1表不存在时
2.
insert into t2 select * from user
insert into t3(a, c, d) select a,c,5 from user
注：t2,t3表必须存在
mysql复制表数据
原文：http://www.cnblogs.com/liuyifan/p/4985189.html
