mysql 1701,MySQL ERROR 1701 (42000)

清空具有外键约束的表时报ERROR 1701(42000)的解决

mysql> truncate table events;

ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (`zabbix`.`acknowledges`, CONSTRAINT `c_acknowledges_2` FOREIGN KEY (`eventid`) REFERENCES `zabbix`.`events` (`eventid`))

mysql> SET foreign_key_checks=0;

Query OK, 0 rows affected (0.00 sec)

mysql> truncate table events;

Query OK, 0 rows affected (0.49 sec)

mysql> optimize table events;

+---------------+----------+----------+-------------------------------------------------------------------+

| Table | Op | Msg_type | Msg_text |

+---------------+----------+----------+-------------------------------------------------------------------+

| zabbix.events | optimize | note | Table does not support optimize, doing recreate + analyze instead |

| zabbix.events | optimize | status | OK |

+---------------+----------+----------+-------------------------------------------------------------------+

2 rows in set (0.29 sec)

mysql> SET foreign_key_checks=1;

Query OK, 0 rows affected (0.00 sec)