mysql复制表结构及数据

复制t1表结构到t2
create table t2 like t1


复制表t1的数据到t3
insert into t3 select * from t1;

原文地址:https://www.cnblogs.com/luleiitlife/p/8545079.html