1. 复制表结构
CREATE TABLE newuser LIKE user;
2. 导入数据
INSERT INTO newauser SELECT * FROM user;
1. 复制表结构
CREATE TABLE newuser LIKE user;
2. 导入数据
INSERT INTO newauser SELECT * FROM user;
转载于:https://www.cnblogs.com/zsg88/p/9810021.html