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
: TheCREATE TRIGGER
statement that defines the trigger.character_set_client
: The session value of thecharacter_set_client
system variable when the trigger was created.collation_connection
: The session value of thecollation_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.3.27, “The INFORMATION_SCHEMA TRIGGERS Table”.