The 2020-12-04: mysql tables allow how many TRIGGERS? # # f greatly architects a daily topic

CodePudding user response:

Six 1, BEFORE the INSERT 2, AFTER INSERT 3, 4, BEFORE the UPDATE AFTER the UPDATE 5, BEFORE the DELETE 6, AFTER the DELETE

CodePudding user response:

6
BEFORE the INSERT
AFTER INSERT
BEFORE the UPDATE
AFTER the UPDATE
BEFORE the DELETE
AFTER the DELETE

CodePudding user response:

2, 6 1, BEFORE the INSERT AFTER INSERT 3, BEFORE the UPDATE 4, 5, AFTER the UPDATE BEFORE the DELETE 6, AFTER the DELETE

CodePudding user response:

There are three main types of triggers: INSERT, UPDATE, and DELETE

CodePudding user response:

reference 4 floor KeepSayingNo response:

there are three main types of triggers: INSERT, UPDATE, DELETE

Upstairs said yes, three categories