In which order MySQL will invoke the triggers if we created multiple triggers of same event and action time?

In this case, MySQL will invoke the triggers in the order in which they are created. But with the help of following options, we can change the order −

FOLLOWS option

This option allows the new trigger to activate after the existing trigger.

Syntax

FOR EACH ROW FOLLOWS trigger_name

PRECEDES option

This option allows the new trigger to activate before the existing trigger.

Syntax

FOR EACH ROW PRECEDES trigger_name

Chandu yadav

e

Updated on: 22-Jun-2020

184 Views

Kickstart Your Career

Get certified by completing the course

Get Started