数据表备份

1.单表备份

-- 复制表结构(主键,索引也会复制)

CREATE TABLE user123 LIKE user;

-- 插入数据

INSERT INTO user123 SELECT * FROM user