触发器是属于某一张表的,当这张表执行插入,更新或删除操作时,就导致触发器的激活。
SHOW TRIGGERS;
该语句用于查询触发器。
2. 使用举例
运行:SHOW TRIGGERS;
输出的主要信息如下:
| Trigger | Event | Table | Statement | Timing | Created | sql_mode | trg_del_org_user | Delete | t_organization | BEGIN BEGIN insert into tmp_base_event values(NEW.army_move_event_id, NEW.version, NEW.start_time, NEW.end_time, NEW.type); END