【原创】Mysql ERROR 17…

mysql 删除含有主键为它表外键时引发的外键异常。

mysql> truncate table movies;

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

只需要将外键约束设置为0, 即可删除。

mysql> set foreign_key_checks=0;

Query OK, 0 rows affected (0.00 sec)

mysql> truncate table movies;

Query OK, 0 rows affected (0.22 sec)

mysql> set foreign_key_checks=1;

Query OK, 0 rows affected (0.00 sec)

mysql> truncate table movies;

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

如图：