在级联删除中触发呼叫 [英] Trigger calls in cascade deleting
问题描述
我在MySQL中有表"A".它具有一些引用,这些引用已级联删除到其他一些表("B","C","D" ...).当某事从"A"删除时,我需要使用触发器.当我直接从"A"中删除记录时,此触发器有效.但是它不适用于级联删除. 我的触发器可用于级联删除时,是否存在任何版本的MySQL?或者,也许还有另一种呼叫方式
I have table "A" in MySQL. It has some references with cascade deleting to some other tables ("B", "C", "D" ...). I need to use a trigger when something deletes from "A". This trigger works when I delete records from "A" directly. But it doesn't work with cascade deleting. Does any version of MySQL exist where my trigger will work with cascade deleting? Or, maybe, there is another way to call
推荐答案
来自 http://dev.mysql.com/doc/refman/5.6/en/innodb-restrictions.html
级联的外键动作不会激活触发器
Cascaded foreign key actions do not activate triggers
换句话说,您不能将触发器与级联删除一起使用.
In other words, you cannot use the trigger with cascaded deleting.
另请参阅相关错误:
- MySQL: https://bugs.mysql.com/bug.php?id = 11472
- MariaDB: https://jira.mariadb.org/browse/MDEV-19402
- MySQL: https://bugs.mysql.com/bug.php?id=11472
- MariaDB: https://jira.mariadb.org/browse/MDEV-19402
这篇关于在级联删除中触发呼叫的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!