- 13.7.5 SHOW Syntax
- 13.7.5.1 SHOW AUTHORS Syntax
- 13.7.5.2 SHOW BINARY LOGS Syntax
- 13.7.5.3 SHOW BINLOG EVENTS Syntax
- 13.7.5.4 SHOW CHARACTER SET Syntax
- 13.7.5.5 SHOW COLLATION Syntax
- 13.7.5.6 SHOW COLUMNS Syntax
- 13.7.5.7 SHOW CONTRIBUTORS Syntax
- 13.7.5.8 SHOW CREATE DATABASE Syntax
- 13.7.5.9 SHOW CREATE EVENT Syntax
- 13.7.5.10 SHOW CREATE FUNCTION Syntax
- 13.7.5.11 SHOW CREATE PROCEDURE Syntax
- 13.7.5.12 SHOW CREATE TABLE Syntax
- 13.7.5.13 SHOW CREATE TRIGGER Syntax
- 13.7.5.14 SHOW CREATE VIEW Syntax
- 13.7.5.15 SHOW DATABASES Syntax
- 13.7.5.16 SHOW ENGINE Syntax
- 13.7.5.17 SHOW ENGINES Syntax
- 13.7.5.18 SHOW ERRORS Syntax
- 13.7.5.19 SHOW EVENTS Syntax
- 13.7.5.20 SHOW FUNCTION CODE Syntax
- 13.7.5.21 SHOW FUNCTION STATUS Syntax
- 13.7.5.22 SHOW GRANTS Syntax
- 13.7.5.23 SHOW INDEX Syntax
- 13.7.5.24 SHOW MASTER STATUS Syntax
- 13.7.5.25 SHOW OPEN TABLES Syntax
- 13.7.5.26 SHOW PLUGINS Syntax
- 13.7.5.27 SHOW PRIVILEGES Syntax
- 13.7.5.28 SHOW PROCEDURE CODE Syntax
- 13.7.5.29 SHOW PROCEDURE STATUS Syntax
- 13.7.5.30 SHOW PROCESSLIST Syntax
- 13.7.5.31 SHOW PROFILE Syntax
- 13.7.5.32 SHOW PROFILES Syntax
- 13.7.5.33 SHOW RELAYLOG EVENTS Syntax
- 13.7.5.34 SHOW SLAVE HOSTS Syntax
- 13.7.5.35 SHOW SLAVE STATUS Syntax
- 13.7.5.36 SHOW STATUS Syntax
- 13.7.5.37 SHOW TABLE STATUS Syntax
- 13.7.5.38 SHOW TABLES Syntax
- 13.7.5.39 SHOW TRIGGERS Syntax
- 13.7.5.40 SHOW VARIABLES Syntax
- 13.7.5.41 SHOW WARNINGS Syntax
SHOW CREATE TRIGGER trigger_name
This statement shows the CREATE
TRIGGER statement that creates the named 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
the following columns:
Trigger: The trigger name.sql_mode: The SQL mode in effect when the trigger executes.SQL Original Statement: TheCREATE TRIGGERstatement that defines the trigger.character_set_client: The session value of thecharacter_set_clientsystem variable when the trigger was created.collation_connection: The session value of thecollation_connectionsystem variable when the trigger was created.Database Collation: The collation of the database with which the trigger is associated.
You can also obtain information about trigger objects from
INFORMATION_SCHEMA, which contains a
TRIGGERS table. See
Section 21.26, “The INFORMATION_SCHEMA TRIGGERS Table”.
User Comments