SHOW CREATE TRIGGER Syntax


This statement shows a CREATE TRIGGER statement that creates the given trigger.

mysql> SHOW CREATE TRIGGER ins_sum\G
*************************** 1. row ***************************
 Trigger: ins_sum
 sql_mode:
SQL Original Statement: CREATE DEFINER=`bob`@`localhost` TRIGGER ins_sum
 BEFORE INSERT ON account
 FOR EACH ROW SET @sum = @sum + NEW.amount
 character_set_client: latin1
 collation_connection: latin1_swedish_ci
 Database Collation: latin1_swedish_ci

You can also obtain information about trigger objects from INFORMATION_SCHEMA, which contains a TRIGGERS table. See , "The INFORMATION_SCHEMA TRIGGERS Table".

Retornar