1.create table 备份 like 主表(备份结构) 2. INSERT INTO 备份表 SELECT * FROM user;(备份数据) 转载于:https://www.cnblogs.com/potatoChicken/p/11589359.html