select TRIGGER_CATALOG, TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, EVENT_OBJECT_CATALOG, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_ORDER, ACTION_CONDITION, ACTION_ORIENTATION, ACTION_TIMING from information_schema.triggers where EVENT_OBJECT_TABLE like '%ShortCodeFeature%'; 5.5.37 +-----------------+----------------+--------------------------------+--------------------+----------------------+---------------------+--------------------+--------------+------------------+--------------------+---------------+ | TRIGGER_CATALOG | TRIGGER_SCHEMA | TRIGGER_NAME | EVENT_MANIPULATION | EVENT_OBJECT_CATALOG | EVENT_OBJECT_SCHEMA | EVENT_OBJECT_TABLE | ACTION_ORDER | ACTION_CONDITION | ACTION_ORIENTATION | ACTION_TIMING | +-----------------+----------------+--------------------------------+--------------------+----------------------+---------------------+--------------------+--------------+------------------+--------------------+---------------+ | def | mnode_cm_data | tr_ShortCodeFeature_warning | INSERT | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | BEFORE | | def | mnode_cm_data | tr_ShortCodeFeature_insert | INSERT | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_ShortCodeFeature_updWarning | UPDATE | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | BEFORE | | def | mnode_cm_data | tr_ShortCodeFeature_update | UPDATE | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_ShortCodeFeature_delete | DELETE | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_shortCodefeature_warning | INSERT | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | BEFORE | | def | mnode_cm_data | tr_shortCodefeature_insert | INSERT | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_shortCodefeature_updWarning | UPDATE | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | BEFORE | | def | mnode_cm_data | tr_shortCodefeature_update | UPDATE | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_shortCodefeature_delete | DELETE | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | AFTER | +-----------------+----------------+--------------------------------+--------------------+----------------------+---------------------+--------------------+--------------+------------------+--------------------+---------------+ show triggers like '%ShortCodeFeature%'; +--------------------------------+--------+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation | +--------------------------------+--------+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | tr_ShortCodeFeature_warning | INSERT | ShortCodeFeature | | BEFORE | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_ShortCodeFeature_insert | INSERT | ShortCodeFeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_ShortCodeFeature_updWarning | UPDATE | ShortCodeFeature | | BEFORE | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_ShortCodeFeature_update | UPDATE | ShortCodeFeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_ShortCodeFeature_delete | DELETE | ShortCodeFeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | +--------------------------------+--------+------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ 5 rows in set (0.01 sec) 10.0.19 select TRIGGER_CATALOG, TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, EVENT_OBJECT_CATALOG, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE, ACTION_ORDER, ACTION_CONDITION, ACTION_ORIENTATION, ACTION_TIMING from information_schema.triggers where EVENT_OBJECT_TABLE like '%ShortCodeFeature%'; +-----------------+----------------+--------------------------------+--------------------+----------------------+---------------------+--------------------+--------------+------------------+--------------------+---------------+ | TRIGGER_CATALOG | TRIGGER_SCHEMA | TRIGGER_NAME | EVENT_MANIPULATION | EVENT_OBJECT_CATALOG | EVENT_OBJECT_SCHEMA | EVENT_OBJECT_TABLE | ACTION_ORDER | ACTION_CONDITION | ACTION_ORIENTATION | ACTION_TIMING | +-----------------+----------------+--------------------------------+--------------------+----------------------+---------------------+--------------------+--------------+------------------+--------------------+---------------+ | def | mnode_cm_data | tr_ShortCodeFeature_warning | INSERT | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | BEFORE | | def | mnode_cm_data | tr_ShortCodeFeature_insert | INSERT | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_ShortCodeFeature_updWarning | UPDATE | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | BEFORE | | def | mnode_cm_data | tr_ShortCodeFeature_update | UPDATE | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_ShortCodeFeature_delete | DELETE | def | mnode_cm_data | ShortCodeFeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_shortCodefeature_warning | INSERT | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | BEFORE | | def | mnode_cm_data | tr_shortCodefeature_insert | INSERT | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_shortCodefeature_updWarning | UPDATE | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | BEFORE | | def | mnode_cm_data | tr_shortCodefeature_update | UPDATE | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | AFTER | | def | mnode_cm_data | tr_shortCodefeature_delete | DELETE | def | mnode_cm_data | shortCodefeature | 0 | NULL | ROW | AFTER | +-----------------+----------------+--------------------------------+--------------------+----------------------+---------------------+--------------------+--------------+------------------+--------------------+---------------+ show triggers like '%ShortCodeFeature%'; +--------------------------------+--------+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation | +--------------------------------+--------+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | tr_ShortCodeFeature_warning | INSERT | ShortCodeFeature | | BEFORE | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_ShortCodeFeature_insert | INSERT | ShortCodeFeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_ShortCodeFeature_updWarning | UPDATE | ShortCodeFeature | | BEFORE | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_ShortCodeFeature_update | UPDATE | ShortCodeFeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_ShortCodeFeature_delete | DELETE | ShortCodeFeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_shortCodefeature_warning | INSERT | shortCodefeature | | BEFORE | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_shortCodefeature_insert | INSERT | shortCodefeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_shortCodefeature_updWarning | UPDATE | shortCodefeature | | BEFORE | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_shortCodefeature_update | UPDATE | shortCodefeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | | tr_shortCodefeature_delete | DELETE | shortCodefeature | | AFTER | NULL | NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | latin1 | latin1_swedish_ci | latin1_swedish_ci | +--------------------------------+--------+------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------+---------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ 10 rows in set (0.01 sec)