Syntax:
SHOW TRIGGERS [FROM db_name] [LIKE expr]

SHOW TRIGGERS lists the triggers currently defined on the MySQL server.
This statement requires the SUPER privilege. It was implemented in
MySQL 5.0.10.

For the trigger ins_sum as defined in
http://dev.mysql.com/doc/refman/5.0/en/using-triggers.html, 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

URL: http://dev.mysql.com/doc/refman/5.0/en/show-triggers.html

