取消外键约束 SET character_set_client = utf8; SET FOREIGN_KEY_CHECKS = 0; LOCK TABLES 数据库名.表名 WRITE; 启用外键约束 UNLOCK TABLES; SET FOREIGN_KEY_CHECKS = 1;