MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
SHOW CREATE TRIGGER trigger_name
This statement shows the CREATE
TRIGGER
statement that creates the named trigger. This
statement requires the TRIGGER
privilege for the table associated with the trigger.
mysql> SHOW CREATE TRIGGER ins_sum\G
*************************** 1. row ***************************
Trigger: ins_sum
sql_mode: NO_ENGINE_SUBSTITUTION
SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ins_sum
BEFORE INSERT ON account
FOR EACH ROW SET @sum = @sum + NEW.amount
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: latin1_swedish_ci
SHOW CREATE TRIGGER
output has
these columns:
Trigger
: The trigger name.
sql_mode
: The SQL mode in effect when the
trigger executes.
SQL Original Statement
: The
CREATE TRIGGER
statement that
defines the trigger.
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.
Trigger information is also available from the
INFORMATION_SCHEMA
TRIGGERS
table. See
Section 21.27, “The INFORMATION_SCHEMA TRIGGERS Table”.