TRIGGER_CATALOG

触发器所属的目录名称。该值始终为 def。The name of the catalog to which the trigger belongs. This value is always def.

TRIGGER_SCHEMA

触发器所属的模式（数据库）名称。The name of the schema (database) to which the trigger belongs.

TRIGGER_NAME

触发器的名称。The name of the trigger.

EVENT_MANIPULATION

触发事件。这是触发器激活时关联表上的操作类型。该值为 INSERT（插入了一行）、DELETE（删除了一行）或 UPDATE（修改了一行）。The trigger event. This is the type of operation on the associated table for which the trigger activates. The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified).

EVENT_OBJECT_CATALOG、EVENT_OBJECT_SCHEMA 和 EVENT_OBJECT_TABLEEVENT_OBJECT_CATALOG, EVENT_OBJECT_SCHEMA, and EVENT_OBJECT_TABLE

如在第 27.3 节，“使用触发器”中所述，每个触发器都与恰好一个表相关。这些列分别指示该表所在的目录和模式（数据库），以及表名。EVENT_OBJECT_CATALOG的值总是def。As noted in Section 27.3, “Using Triggers”, every trigger is associated with exactly one table. These columns indicate the catalog and schema (database) in which this table occurs, and the table name, respectively. The EVENT_OBJECT_CATALOG value is always def.

ACTION_ORDER

触发器在具有相同EVENT_MANIPULATION和ACTION_TIMING值的同一表上的触发器列表中的顺序位置。The ordinal position of the trigger's action within the list of triggers on the same table with the same EVENT_MANIPULATION and ACTION_TIMING values.

ACTION_CONDITION

该值始终为NULL。This value is always NULL.

ACTION_STATEMENT

触发器主体；即触发器激活时执行的语句。此文本使用 UTF-8 编码。The trigger body; that is, the statement executed when the trigger activates. This text uses UTF-8 encoding.

ACTION_ORIENTATION

此值始终为 ROW。This value is always ROW.

ACTION_TIMING

触发器是在触发事件之前还是之后激活。该值为 BEFORE 或 AFTER。Whether the trigger activates before or after the triggering event. The value is BEFORE or AFTER.

ACTION_REFERENCE_OLD_TABLE

该值始终为NULL。This value is always NULL.

ACTION_REFERENCE_NEW_TABLE

该值始终为NULL。This value is always NULL.

ACTION_REFERENCE_OLD_ROW 和 ACTION_REFERENCE_NEW_ROWACTION_REFERENCE_OLD_ROW and ACTION_REFERENCE_NEW_ROW

分别为旧列和新列的标识符。ACTION_REFERENCE_OLD_ROW 的值始终为 OLD，ACTION_REFERENCE_NEW_ROW 的值始终为 NEW。The old and new column identifiers, respectively. The ACTION_REFERENCE_OLD_ROW value is always OLD and the ACTION_REFERENCE_NEW_ROW value is always NEW.

CREATED

触发器创建的日期和时间。对于触发器，这是一个 TIMESTAMP(2) 值（带有百分之一秒的小数部分）。The date and time when the trigger was created. This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers.

SQL_MODE

创建触发器时生效的 SQL 模式，以及触发器执行时使用的 SQL 模式。有关允许值，请参见 第 7.1.11 节 “服务器 SQL 模式”。The SQL mode in effect when the trigger was created, and under which the trigger executes. For the permitted values, see Section 7.1.11, “Server SQL Modes”.

DEFINERDEFINER

DEFINER 子句中指定的账户名称（通常是创建触发器的用户），格式为 'user_name'@'host_name'。The account named in the DEFINER clause (often the user who created the trigger), in 'user_name'@'host_name' format.

CHARACTER_SET_CLIENT

创建触发器时 character_set_client 系统变量的会话值。The session value of the character_set_client system variable when the trigger was created.

COLLATION_CONNECTION

创建触发器时 collation_connection 系统变量的会话值。The session value of the collation_connection system variable when the trigger was created.

DATABASE_COLLATION

与触发器相关联的数据库排序规则。The collation of the database with which the trigger is associated.