简单的几个SQL语句,将数据库的A表快速备份到B表中: DROP TABLE IF EXISTS B; CREATE TABLE B LIKE A; INSERT INTO B SELECT * FROM A;