- 12.4.5 SHOW Syntax
- 12.4.5.1 SHOW BINARY LOGS Syntax
- 12.4.5.2 SHOW BINLOG EVENTS Syntax
- 12.4.5.3 SHOW CHARACTER SET Syntax
- 12.4.5.4 SHOW COLLATION Syntax
- 12.4.5.5 SHOW COLUMNS Syntax
- 12.4.5.6 SHOW CREATE DATABASE Syntax
- 12.4.5.7 SHOW CREATE FUNCTION Syntax
- 12.4.5.8 SHOW CREATE PROCEDURE Syntax
- 12.4.5.9 SHOW CREATE TABLE Syntax
- 12.4.5.10 SHOW CREATE VIEW Syntax
- 12.4.5.11 SHOW DATABASES Syntax
- 12.4.5.12 SHOW ENGINE Syntax
- 12.4.5.13 SHOW ENGINES Syntax
- 12.4.5.14 SHOW ERRORS Syntax
- 12.4.5.15 SHOW FUNCTION CODE Syntax
- 12.4.5.16 SHOW FUNCTION STATUS Syntax
- 12.4.5.17 SHOW GRANTS Syntax
- 12.4.5.18 SHOW INDEX Syntax
- 12.4.5.19 SHOW INNODB STATUS Syntax
- 12.4.5.20 SHOW LOGS Syntax
- 12.4.5.21 SHOW MASTER STATUS Syntax
- 12.4.5.22 SHOW MUTEX STATUS Syntax
- 12.4.5.23 SHOW OPEN TABLES Syntax
- 12.4.5.24 SHOW PRIVILEGES Syntax
- 12.4.5.25 SHOW PROCEDURE CODE Syntax
- 12.4.5.26 SHOW PROCEDURE STATUS Syntax
- 12.4.5.27 SHOW PROCESSLIST Syntax
- 12.4.5.28 SHOW PROFILE Syntax
- 12.4.5.29 SHOW PROFILES Syntax
- 12.4.5.30 SHOW SLAVE HOSTS Syntax
- 12.4.5.31 SHOW SLAVE STATUS Syntax
- 12.4.5.32 SHOW STATUS Syntax
- 12.4.5.33 SHOW TABLE STATUS Syntax
- 12.4.5.34 SHOW TABLES Syntax
- 12.4.5.35 SHOW TRIGGERS Syntax
- 12.4.5.36 SHOW VARIABLES Syntax
- 12.4.5.37 SHOW WARNINGS Syntax
SHOW TRIGGERS [{FROM | IN} db_name]
[LIKE 'pattern' | WHERE expr]
SHOW TRIGGERS lists the triggers
currently defined for tables in a database (the default database
unless a FROM clause is given). This
statement requires the SUPER
privilege. It was implemented in MySQL 5.0.10. The
LIKE clause, if present, indicates
which table names to match and causes the statement to display
triggers for those tables. The WHERE clause
can be given to select rows using more general conditions, as
discussed in Section 19.19, “Extensions to SHOW Statements”.
For the trigger ins_sum as defined in
Section 18.3, “Using Triggers”, the output of this statement is as
shown here:
mysql> SHOW TRIGGERS LIKE 'acc%'\G
*************************** 1. row ***************************
Trigger: ins_sum
Event: INSERT
Table: account
Statement: SET @sum = @sum + NEW.amount
Timing: BEFORE
Created: NULL
sql_mode:
Definer: myname@localhost
Note
When using a LIKE clause with
SHOW TRIGGERS, the expression
to be matched (expr) is compared
with the name of the table on which the trigger is declared,
and not with the name of the trigger:
mysql> SHOW TRIGGERS LIKE 'ins%';
Empty set (0.01 sec)
A brief explanation of the columns in the output of this statement is shown here:
-
TriggerThe name of the trigger.
-
EventThe event that causes trigger activation: one of
'INSERT','UPDATE', or'DELETE'. -
TableThe table for which the trigger is defined.
-
StatementThe statement to be executed when the trigger is activated. This is the same as the text shown in the
ACTION_STATEMENTcolumn ofINFORMATION_SCHEMA.TRIGGERS. -
TimingOne of the two values
'BEFORE'or'AFTER'. -
CreatedCurrently, the value of this column is always
NULL. -
The SQL mode in effect when the trigger executes. This column was added in MySQL 5.0.11.
-
DefinerThe account that created the trigger. This column was added in MySQL 5.0.17.
You must have the SUPER privilege
to execute SHOW TRIGGERS.
See also Section 19.16, “The INFORMATION_SCHEMA TRIGGERS Table”.
User Comments
Add your own comment.