Bug #10565 SHOW TRIGGERS is missing.
Submitted: 12 May 2005 0:32 Modified: 2 Aug 2005 14:34
Reporter: MySQL-Front Team Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.4-beta OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[12 May 2005 0:32] MySQL-Front Team 
Description:
Like mentioned in the manual I can create triggers:

CREATE TABLE account (acct_num INT, amount DECIMAL(10,2));
CREATE TRIGGER ins_sum BEFORE INSERT ON account
  FOR EACH ROW SET @sum = @sum + 1;

But I miss an option to find out if triggers are already exists and if yes what they do:

SHOW TIGGERS;
SHOW CREATE TRIGGER TableName;

How to repeat:
SHOW TIGGERS;
SHOW CREATE TRIGGER TableName;

... generates bugs.
[12 May 2005 0:48] MySQL Verification Team 
Thank you for the bug report.
[2 Aug 2005 2:44] Arjen Lentz 
MySQL 5.0.10 implements SHOW TRIGGERS
[2 Aug 2005 14:34] MySQL-Front Team 
Yes