How do you list all triggers in a MySQL database

Question

What is the command to list all triggers in a MySQL database

User · Answer

For showing a particular trigger in a particular schema you can try the following   select   from information schema triggers where  information schema triggers trigger name like   trigger name   and  information schema triggers trigger schema like   data base name

User · Answer

The command for listing all triggers is   show triggers    or you can access the INFORMATION SCHEMA table directly by   select trigger schema  trigger name  action statement from information schema triggers    You can do this from version 5 0 10 onwards  More information about the TRIGGERS table is here

User · Answer

You can use below to find a particular trigger definition   SHOW TRIGGERS LIKE   trigger name   G   or the below to show all the triggers in the database  It will work for MySQL 5 0 and above   SHOW TRIGGERS G

User · Answer

I hope following code will give you more information   select   from information schema triggers where  information schema triggers trigger schema like   your db name     This will give you total 22 Columns in MySQL version  5 5 27 and Above  TRIGGER CATALOG  TRIGGER SCHEMA TRIGGER NAME EVENT MANIPULATION EVENT OBJECT CATALOG EVENT OBJECT SCHEMA  EVENT OBJECT TABLE ACTION ORDER ACTION CONDITION ACTION STATEMENT ACTION ORIENTATION ACTION TIMING ACTION REFERENCE OLD TABLE ACTION REFERENCE NEW TABLE ACTION REFERENCE OLD ROW ACTION REFERENCE NEW ROW CREATED  SQL MODE DEFINER  CHARACTER SET CLIENT COLLATION CONNECTION DATABASE COLLATION

[mysql] How do you list all triggers in a MySQL database?

Examples related to mysql

Examples related to triggers