备份表结构和数据 将数据库的A表快速备份到B表中: 方法1: DROP TABLE IF EXISTS B; CREATE TABLE B LIKE A; INSERT INTO B SELECT * FROM A; 方法2: SELECT * INTO A_copy FROM A;