mysql复制表数据

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表必须存在