Press CTRL+C to copySHOW 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.
Press CTRL+C to copymysql> SHOW CREATE TRIGGER ins_sum\G *************************** 1. row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,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 Created: 2018-08-08 10:10:07.90
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.Created
: The date and time when the trigger was created. This is aTIMESTAMP(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.
Trigger information is also available from the
INFORMATION_SCHEMA
TRIGGERS
table. See
Section 24.3.29, “The INFORMATION_SCHEMA TRIGGERS Table”.