清空具有外鍵約束的表時報ERROR 1701(42000)的解決

清空具有外鍵約束的表時報ERROR 1701(42000)的解決      ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key
constraint (`furion`.`tbl_frn_alert`, CONSTRAINT `FK353A3CBEB139CC08`
FOREIGN KEY (`endpt_id`) REFERENCES `furion`.`tbl_frn_endpt` (`id`))   www.2cto.com   解決方法：   mysql> SET foreign_key_checks=0;    刪除後   mysql> SET foreign_key_checks=1;