ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint

## ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (bookstore.bookinfo, CONSTRAINT bookinfo_ibfk_1)]

在删除mysql表的数据时提示如下错误：ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (bookstore.bookinfo, CONSTRAINT bookinfo_ibfk_1)]

翻译为错误1701（42000）：无法截断外键约束（bookstore.bookinfo，约束bookinfo\u ibfk\u 1）中引用的表]

原因：该表设有外键，需要先将外键约束清空再进行数据删除，此时才会删除成功，删除成功后需要再将外键约束置1.

SET FOREIGN_KEY_CHECKS = 0;   //外键约束清空
TRUNCATE 表名;              //删除数据
SET FOREIGN_KEY_CHECKS = 1;   //外键约束设置1