为什么mysql可以存在两个同类型触发器 ,而且都起作用?

[楚荆]

据说mysql不能存在两个同类型触发器. 然而我新建了两个before update触发器,居然没报错,还能正常工作, 这是为什么?

[qq_39651978]

你用的系统是32还是64

[楚荆]

引用 1 楼 qq_39651978 的回复:

你用的系统是32还是64

64, 这有影响吗?

[ACMAIN_CHM]

看不清楚楼主的图，建议发贴提问时请用文本。命令窗中的文字是可以复制的。

[楚荆]

引用 3 楼 ACMAIN_CHM 的回复:

看不清楚楼主的图，建议发贴提问时请用文本。命令窗中的文字是可以复制的。

如果用电脑的话点一下就好, 不过你可能用的手机

[zjcxc]

版本问题吧？ 官网文档上 Before MySQL 5.7.2, there cannot be multiple triggers for a given table that have the same trigger event and action time. For example, you cannot have two BEFORE UPDATE triggers for a table. But you can have a BEFORE UPDATE and a BEFORE INSERT trigger, or a BEFORE UPDATE and an AFTER UPDATE trigger.

[楚荆]

引用 5 楼 zjcxc 的回复:

版本问题吧？ 官网文档上 Before MySQL 5.7.2, there cannot be multiple triggers for a given table that have the same trigger event and action time. For example, you cannot have two BEFORE UPDATE triggers for a table. But you can have a BEFORE UPDATE and a BEFORE INSERT trigger, or a BEFORE UPDATE and an AFTER UPDATE trigger.

果真如此 As of MySQL 5.7.2, it is possible to define multiple triggers for a given table that have the same trigger event and action time. For example, you can have two BEFORE UPDATE triggers for a table. https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html