13.5.4.26. SHOW TRIGGERS Syntax
SHOW TRIGGERS [FROM db_name] [LIKE expr]
SHOW TRIGGERS lists the triggers currently
defined on the MySQL server. This statement requires the
SUPER privilege.
For the trigger ins_sum as defined in
Section 20.3, “Using Triggers”, the output of this statement
is as shown here:
mysql> SHOW TRIGGERS LIKE 'acc%'\G
*************************** 1. row ***************************
Trigger: ins_sum
Event: INSERT
Table: account
Statement: SET @sum = @sum + NEW.amount
Timing: BEFORE
Created: NULL
sql_mode:
Definer: myname@localhost
Note: When using a
LIKE clause with SHOW
TRIGGERS, the expression to be matched
(expr) is compared with the name of
the table on which the trigger is declared, and not with the
name of the trigger:
mysql> SHOW TRIGGERS LIKE 'ins%';
Empty set (0.01 sec)
A brief explanation of the columns in the output of this
statement is shown here:
-
Trigger
The name of the trigger.
-
Event
The event that causes trigger activation: one of
'INSERT', 'UPDATE',
or 'DELETE'.
-
Table
The table for which the trigger is defined.
-
Statement
The statement to be executed when the trigger is
activated. This is the same as the text shown in the
ACTION_STATEMENT column of
INFORMATION_SCHEMA.TRIGGERS.
-
Timing
One of the two values 'BEFORE' or
'AFTER'.
-
Created
Currently, the value of this column is always
NULL.
-
sql_mode
The SQL mode in effect when the trigger executes.
-
Definer
The account that created the trigger.
See also Section 23.16, “The INFORMATION_SCHEMA TRIGGERS Table”.
