Bug #10994 ALTER/SHOW TRIGGERS
Submitted: 31 May 2005 17:10 Modified: 21 Jul 2005 3:44
Reporter: Marcelo Miglioli Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.4 OS:Windows (WIndow 2k)
Assigned to: Antony Curtis CPU Architecture:Any

[31 May 2005 17:10] Marcelo Miglioli
Description:
I try to use triggers in mysql 5.0.4.
I' am create diferent triggers but not Show the list of triggers for the table, not modify with ALTER TRIGGER...
 

How to repeat:
show triggers....
[31 May 2005 17:57] MySQL Verification Team
This bug reported is associated to bug http://bugs.mysql.com/bug.php?id=9586
regarding the show triggers.
[3 Jul 2005 18:40] Antony Curtis
See Bug#5892
[19 Jul 2005 20:35] Dmitry Lenev
Support for SHOW TRIGGERS command and INFORMATION_SCHEMA.TRIGGERS view
was implemented in version 5.0.10 of MySQL server. There are no plans to implement ALTER TRIGGER command currently.
[21 Jul 2005 3:44] Jon Stephens
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

Additional info:

SHOW TRIGGERS implemented in 5.0.10 (and documented) per Bug#9586.

Closing this bug as a dupe.