- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
- 12.5.5 SHOW Syntax
- 12.5.5.1 SHOW AUTHORS Syntax
- 12.5.5.2 SHOW BINARY LOGS Syntax
- 12.5.5.3 SHOW BINLOG EVENTS Syntax
- 12.5.5.4 SHOW CHARACTER SET Syntax
- 12.5.5.5 SHOW COLLATION Syntax
- 12.5.5.6 SHOW COLUMNS Syntax
- 12.5.5.7 SHOW CONTRIBUTORS Syntax
- 12.5.5.8 SHOW CREATE DATABASE Syntax
- 12.5.5.9 SHOW CREATE EVENT
- 12.5.5.10 SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax
- 12.5.5.11 SHOW CREATE TABLE Syntax
- 12.5.5.12 SHOW CREATE TRIGGER Syntax
- 12.5.5.13 SHOW CREATE VIEW Syntax
- 12.5.5.14 SHOW DATABASES Syntax
- 12.5.5.15 SHOW ENGINE Syntax
- 12.5.5.16 SHOW ENGINES Syntax
- 12.5.5.17 SHOW ERRORS Syntax
- 12.5.5.18 SHOW EVENTS
- 12.5.5.19 SHOW GRANTS Syntax
- 12.5.5.20 SHOW INDEX Syntax
- 12.5.5.21 SHOW INNODB STATUS Syntax
- 12.5.5.22 SHOW MASTER STATUS Syntax
- 12.5.5.23 SHOW OPEN TABLES Syntax
- 12.5.5.24 SHOW PLUGINS Syntax
- 12.5.5.25 SHOW PRIVILEGES Syntax
- 12.5.5.26 SHOW PROCEDURE CODE and SHOW FUNCTION CODE Syntax
- 12.5.5.27 SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax
- 12.5.5.28 SHOW PROCESSLIST Syntax
- 12.5.5.29 SHOW SCHEDULER STATUS Syntax
- 12.5.5.30 SHOW SLAVE HOSTS Syntax
- 12.5.5.31 SHOW SLAVE STATUS Syntax
- 12.5.5.32 SHOW STATUS Syntax
- 12.5.5.33 SHOW TABLE STATUS Syntax
- 12.5.5.34 SHOW TABLES Syntax
- 12.5.5.35 SHOW TRIGGERS Syntax
- 12.5.5.36 SHOW VARIABLES Syntax
- 12.5.5.37 SHOW WARNINGS Syntax
SHOW TRIGGERS [FROMdb_name] [LIKE 'pattern' | WHEREexpr]
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 TRIGGER privilege (prior to
MySQL 5.1.22, it requires the SUPER
privilege). 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 27.27, “Extensions to SHOW Statements”.
For the trigger ins_sum as defined in
Section 24.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
character_set_client: latin1
collation_connection: latin1_swedish_ci
Database Collation: latin1_swedish_ci
character_set_client is the session value of
the character_set_client system variable when
the trigger was created. collation_connection
is the session value of the
collation_connection system variable when the
trigger was created. Database Collation is
the collation of the database with which the trigger is
associated. These columns were added in MySQL 5.1.21.
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. -
sql_modeThe SQL mode in effect when the trigger executes.
-
DefinerThe account that created the trigger.
See also Section 27.16, “The INFORMATION_SCHEMA TRIGGERS Table”.
User Comments
Add your own comment.