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

ERROR 1701 (42000): Cannot truncate a table referenced in a foreign keyconstraint (furion.tbl_frn_alert, CONSTRAINT FK353A3CBEB139CC08FOREIGN KEY (endpt_id) REFERENCES furion.tbl_frn_endpt (id))
www.2cto.com
解決方法：

SET foreign_key_checks=0;

刪除后

mysql> SET foreign_key_checks=1;