The TRIGGERS table provides information about triggers.
mysql> desc INFORMATION_SCHEMA.TRIGGERS;+----------------------------+--------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+----------------------------+--------------+------+-----+---------+-------+| TRIGGER_CATALOG | varchar(512) | YES | | NULL | || TRIGGER_SCHEMA | varchar(64) | NO | | | || TRIGGER_NAME | varchar(64) | NO | | | || EVENT_MANIPULATION | varchar(6) | NO | | | || EVENT_OBJECT_CATALOG | varchar(512) | YES | | NULL | || EVENT_OBJECT_SCHEMA | varchar(64) | NO | | | || EVENT_OBJECT_TABLE | varchar(64) | NO | | | || ACTION_ORDER | bigint(4) | NO | | 0 | || ACTION_CONDITION | longtext | YES | | NULL | || ACTION_STATEMENT | longtext | NO | | | || ACTION_ORIENTATION | varchar(9) | NO | | | || ACTION_TIMING | varchar(6) | NO | | | || ACTION_REFERENCE_OLD_TABLE | varchar(64) | YES | | NULL | || ACTION_REFERENCE_NEW_TABLE | varchar(64) | YES | | NULL | || ACTION_REFERENCE_OLD_ROW | varchar(3) | NO | | | || ACTION_REFERENCE_NEW_ROW | varchar(3) | NO | | | || CREATED | datetime | YES | | NULL | || SQL_MODE | longtext | NO | | | || DEFINER | longtext | NO | | | |+----------------------------+--------------+------+-----+---------+-------+19 rows in set (0.02 sec)
Name (required)
email (will not be published) (required)
Website
