转自:http://blog.sina.com.cn/s/blog_72ef7bea0101f013.html
最近在MySQL Workbench上使用"TRUNCATE TABLE TABLE_E;"清空一个表时返回错误:
Error Code: 1701. Cannot truncate a table referenced in a foreign key constraint (`yqutesting`.`table_f`, CONSTRAINT `table_f_ibfk_4` FOREIGN KEY (`old_id`) REFERENCES `yqutesting`.`table_e` (`ID`))
解决方法1:
删除约束
清空表
手工删除引用该表的记录
创建约束
解决方法2:
SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE TABLE_E;
SET FOREIGN_KEY_CHECKS = 1;