2020-12-04：mysql 表中允许有多少个 TRIGGERS？

[福大大架构师每日一题]

2020-12-04：mysql 表中允许有多少个 TRIGGERS？#福大大架构师每日一题#

[KeepSayingNo]

主要有三种类型的触发器：INSERT、UPDATE、DELETE

[韩_师兄]

引用 4 楼 KeepSayingNo 的回复:

主要有三种类型的触发器：INSERT、UPDATE、DELETE

楼上说的对,三大类

[浪里白条(̿▀̿ ̿Ĺ̯̿̿▀̿ ̿)]

六个 1，BEFORE INSERT 2， AFTER INSERT 3 ，BEFORE UPDATE 4，AFTER UPDATE 5，BEFORE DELETE 6，AFTER DELETE

[亦夜]

6个 BEFORE INSERT AFTER INSERT BEFORE UPDATE AFTER UPDATE BEFORE DELETE AFTER DELETE

[光阴易逝莫负韶华]

6个 1，BEFORE INSERT 2， AFTER INSERT 3 ，BEFORE UPDATE 4，AFTER UPDATE 5，BEFORE DELETE 6，AFTER DELETE