How can we see the information on triggers order in case of multiple triggers for same event and action time?

It can be done with the help of the following query −

mysql> SELECT trigger_name,action_order FROM INFORMATION_SCHEMA.triggers WHERE TRIGGER_SCHEMA = 'query' ORDER BY event_object_table,action_timing,event_manipulation;
+------------------------------+--------------+
| trigger_name                 | action_order |
+------------------------------+--------------+
| studentdetail_before_update  |            1 |
| studentdetail_before_update2 |            2 |
+------------------------------+--------------+
2 rows in set (0.10 sec)

The above result set shows the order of multiple triggers created on the same event and action time in the database ‘query’.

Karthikeya Boyini

Published on 22-Feb-2018 07:41:06

• Related Questions & Answers
• How can we create multiple MySQL triggers for the same trigger event and action time?
• In which order MySQL will invoke the triggers if we created multiple triggers of same event and action time?
• How can we get the metadata of triggers?
• How to get all the MySQL triggers and the triggers for only the current database
• How can we check the list of all triggers in a database?
• How can we emulate CHECK CONSTRAINT by using triggers?
• How can we use SIGNAL statement with MySQL triggers?
• How to use Boto3 to get the details of multiple triggers at a time?
• What are TRIGGERS in DB2? What is the difference between TRIGGERS and STORED PROCEDURES?
• How we can find all the triggers associated with a particular MySQL table?
• How can we use INFORMATION_SCHEMA to get the details about triggers in a particular database?
• Update MySQL table on INSERT command with triggers?
• What are the advantages, disadvantages and restrictions of using MySQL triggers?
• Difference between stored procedure and triggers in SQL
• Explain about triggers and active databases in DBMS