triggers
概述
此表仅用于兼容 MySQL 行为。永远为空。
所属数据库
information_schema
表信息
| 列名 | 类型 | 说明 |
|---|---|---|
| TRIGGER_CATALOG | varchar(512) | |
| TRIGGER_SCHEMA | varchar(64) | |
| TRIGGER_NAME | varchar(64) | |
| EVENT_MANIPULATION | varchar(6) | |
| EVENT_OBJECT_CATALOG | varchar(512) | |
| EVENT_OBJECT_SCHEMA | varchar(64) | |
| EVENT_OBJECT_TABLE | varchar(64) | |
| ACTION_ORDER | varchar(4) | |
| ACTION_CONDITION | varchar(512) | |
| ACTION_STATEMENT | varchar(512) | |
| ACTION_ORIENTATION | varchar(9) | |
| ACTION_TIMING | varchar(6) | |
| ACTION_REFERENCE_OLD_TABLE | varchar(64) | |
| ACTION_REFERENCE_NEW_TABLE | varchar(64) | |
| ACTION_REFERENCE_OLD_ROW | varchar(3) | |
| ACTION_REFERENCE_NEW_ROW | varchar(3) | |
| CREATED | datetime | |
| SQL_MODE | varchar(8192) | |
| DEFINER | varchar(77) | |
| CHARACTER_SET_CLIENT | varchar(32) | |
| COLLATION_CONNECTION | varchar(32) | |
| DATABASE_COLLATION | varchar(32) |