MySQL中查看触发器trigger的方法

---

• 通常，我们查看对象都有一定的SQL语句，没有的话可以使用information_schema架构上的相关表来查看：
• 比如查看trigger（其他的对象也可以使用同样的方法来查看）
• triggers表结构如下：

mysql> show create table triggers\G*************************** 1. row ***************************       Table: TRIGGERSCreate Table: CREATE TEMPORARY TABLE `TRIGGERS` (  `TRIGGER_CATALOG` varchar(512) NOT NULL DEFAULT '',  `TRIGGER_SCHEMA` varchar(64) NOT NULL DEFAULT '',  `TRIGGER_NAME` varchar(64) NOT NULL DEFAULT '',  `EVENT_MANIPULATION` varchar(6) NOT NULL DEFAULT '',  `EVENT_OBJECT_CATALOG` varchar(512) NOT NULL DEFAULT '',  `EVENT_OBJECT_SCHEMA` varchar(64) NOT NULL DEFAULT '',  `EVENT_OBJECT_TABLE` varchar(64) NOT NULL DEFAULT '',  `ACTION_ORDER` bigint(4) NOT NULL DEFAULT '0',  `ACTION_CONDITION` longtext,  `ACTION_STATEMENT` longtext NOT NULL,  `ACTION_ORIENTATION` varchar(9) NOT NULL DEFAULT '',  `ACTION_TIMING` varchar(6) NOT NULL DEFAULT '',  `ACTION_REFERENCE_OLD_TABLE` varchar(64) DEFAULT NULL,  `ACTION_REFERENCE_NEW_TABLE` varchar(64) DEFAULT NULL,  `ACTION_REFERENCE_OLD_ROW` varchar(3) NOT NULL DEFAULT '',  `ACTION_REFERENCE_NEW_ROW` varchar(3) NOT NULL DEFAULT '',  `CREATED` datetime DEFAULT NULL,  `SQL_MODE` varchar(8192) NOT NULL DEFAULT '',  `DEFINER` varchar(77) NOT NULL DEFAULT '',  `CHARACTER_SET_CLIENT` varchar(32) NOT NULL DEFAULT '',  `COLLATION_CONNECTION` varchar(32) NOT NULL DEFAULT '',  `DATABASE_COLLATION` varchar(32) NOT NULL DEFAULT '') ENGINE=MyISAM DEFAULT CHARSET=utf81 row in set (0.00 sec)

• 查询语句如下:

select trigger_schema ,trigger_name,event_manipulation, action_timing,ACTION_REFERENCE_NEW_ROW from triggers where trigger_schema='t';

---