13.7.5.38 SHOW TRIGGERS Syntax

SHOW TRIGGERS [{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]

SHOW TRIGGERS lists the triggers
currently defined for tables in a database (the default database
unless a FROM clause is given). This
statement returns results only for databases and tables for
which you have the TRIGGER
privilege. The LIKE clause, if
present, indicates which table names to match (not trigger
names) and causes the statement to display triggers for those
tables. The WHERE clause can be given to
select rows using more general conditions, as discussed in
Section 20.31, “Extensions to SHOW Statements”.

Event: The type of operation that causes
trigger activation. The value is
'INSERT', 'UPDATE', or
'DELETE'.

Table: The table for which the trigger is
defined.

Statement: The trigger body; that is, the
statement executed when the trigger activates.

Timing: Whether the trigger activates
before or after the triggering event. The value is
'BEFORE' or 'AFTER'.

Created: 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 created in MySQL
5.7.2 or later, NULL for triggers created
prior to 5.7.2.

sql_mode: The SQL mode in effect when the
trigger executes.

Definer: The account of the user who
created the trigger, in
'user_name'@'host_name'
format.

character_set_client: The session value
of the character_set_client
system variable when the trigger was created.

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.