(mysql.info) triggers-table
Info Catalog
(mysql.info) views-table
(mysql.info) information-schema
(mysql.info) other-information-schema-tables
20.16 The `INFORMATION_SCHEMA TRIGGERS' Table
=============================================
The `TRIGGERS' table provides information about triggers. You must have
the `SUPER' privilege to access this table.
*`INFORMATION_SCHEMA' Name* *`SHOW' Name* *Remarks*
`TRIGGER_CATALOG' `NULL'
`TRIGGER_SCHEMA'
`TRIGGER_NAME' `Trigger'
`EVENT_MANIPULATION' `Event'
`EVENT_OBJECT_CATALOG' `NULL'
`EVENT_OBJECT_SCHEMA'
`EVENT_OBJECT_TABLE' `Table'
`ACTION_ORDER' `0'
`ACTION_CONDITION' `NULL'
`ACTION_STATEMENT' `Statement'
`ACTION_ORIENTATION' `ROW'
`ACTION_TIMING' `Timing'
`ACTION_REFERENCE_OLD_TABLE' `NULL'
`ACTION_REFERENCE_NEW_TABLE' `NULL'
`ACTION_REFERENCE_OLD_ROW' `OLD'
`ACTION_REFERENCE_NEW_ROW' `NEW'
`CREATED' `NULL' (`0')
`SQL_MODE' MySQL extension
`DEFINER' MySQL extension
* The `TRIGGERS' table was added in MySQL 5.0.10.
* The `TRIGGER_SCHEMA' and `TRIGGER_NAME' columns contain the name of
the database in which the trigger occurs and the trigger name,
respectively.
* The `EVENT_MANIPULATION' column contains one of the values
`'INSERT'', `'DELETE'', or `'UPDATE''.
* As noted in triggers, every trigger is associated with
exactly one table. The `EVENT_OBJECT_SCHEMA' and
`EVENT_OBJECT_TABLE' columns contain the database in which this
table occurs, and the table's name.
* The `ACTION_ORDER' statement contains the ordinal position of the
trigger's action within the list of all similar triggers on the
same table. Currently, this value is always `0', because it is not
possible to have more than one trigger with the same
`EVENT_MANIPULATION' and `ACTION_TIMING' on the same table.
* The `ACTION_STATEMENT' column contains the statement to be
executed when the trigger is invoked. This is the same as the text
displayed in the `Statement' column of the output from `SHOW
TRIGGERS'. Note that this text uses UTF-8 encoding.
* The `ACTION_ORIENTATION' column always contains the value `'ROW''.
* The `ACTION_TIMING' column contains one of the two values
`'BEFORE'' or `'AFTER''.
* The columns `ACTION_REFERENCE_OLD_ROW' and
`ACTION_REFERENCE_NEW_ROW' contain the old and new column
identifiers, respectively. This means that
`ACTION_REFERENCE_OLD_ROW' always contains the value `'OLD'' and
`ACTION_REFERENCE_NEW_ROW' always contains the value `'NEW''.
* The `SQL_MODE' column shows the server SQL mode that was in effect
at the time when the trigger was created (and thus which remains
in effect for this trigger whenever it is invoked, _regardless of
the current server SQL mode_). The possible range of values for
this column is the same as that of the `sql_mode' system variable.
See server-sql-mode.
* The `DEFINER' column was added in MySQL 5.0.17. `DEFINER'
indicates who defined the trigger.
* The following columns currently always contain `NULL':
`TRIGGER_CATALOG', `EVENT_OBJECT_CATALOG', `ACTION_CONDITION',
`ACTION_REFERENCE_OLD_TABLE', `ACTION_REFERENCE_NEW_TABLE', and
`CREATED'.
Example, using the `ins_sum' trigger defined in using-triggers:
mysql> SELECT * FROM INFORMATION_SCHEMA.TRIGGERS\G
*************************** 1. row ***************************
TRIGGER_CATALOG: NULL
TRIGGER_SCHEMA: test
TRIGGER_NAME: ins_sum
EVENT_MANIPULATION: INSERT
EVENT_OBJECT_CATALOG: NULL
EVENT_OBJECT_SCHEMA: test
EVENT_OBJECT_TABLE: account
ACTION_ORDER: 0
ACTION_CONDITION: NULL
ACTION_STATEMENT: SET @sum = @sum + NEW.amount
ACTION_ORIENTATION: ROW
ACTION_TIMING: BEFORE
ACTION_REFERENCE_OLD_TABLE: NULL
ACTION_REFERENCE_NEW_TABLE: NULL
ACTION_REFERENCE_OLD_ROW: OLD
ACTION_REFERENCE_NEW_ROW: NEW
CREATED: NULL
SQL_MODE:
DEFINER: me@localhost
See also show-triggers.
Info Catalog
(mysql.info) views-table
(mysql.info) information-schema
(mysql.info) other-information-schema-tables
automatically generated byinfo2html