Bug #29111 Query Browser does not have menu item to show/edit triggers

• Submitted: 14 Jun 2007 16:19
• Modified: 15 Jun 2007 7:34
• Reporter: Kevin McCoy
• Status: Won't fix
• Category: MySQL Query Browser
• Severity: S4 (Feature request)
• Version: 1.2.11
• OS: Windows (Missing feature)
• CPU Architecture: Any

[14 Jun 2007 16:19] Kevin McCoy

Description:
The Query Browser Script menu has items for Script|Create Stored Procedure/Function and Script|Edit All Stored Procedures/Functions. 

There is no simple way (that I can find) to show/edit all the *triggers* for a schema. Triggers do not show up in the procedures & functions "edit all" dump - maybe they should.

How to repeat:
Click Script|Edit All Stored Procedures/Functions

Functions and procedures show up, but triggers do not.

There is no apparent way to edit triggers, short of piecing them back together from the contents of the information_schema:triggers table, or by doing a backup and editing the SQL text.

Am I missing something?

Suggested fix:

Please add "Create Trigger" and "Edit All Triggers" menu items, or add triggers to the existing "Edit All Scripts" feature.

If trigger creation/editing is only available on a localhost MySQL server, then gray the menu items out - or bark at me if I actually try to save a new trigger that requires SUPER privs. I'd at least like to see the triggers, even if I can't modify them remotely.

[15 Jun 2007 7:34] Valeriy Kravchuk

Thank you for a reasonable feature request.

[13 Mar 2014 13:36] Omer Barnir

This bug is not scheduled to be fixed at this time.