Bug #31537 alter statement to stop/disable all events on a specified database
Submitted: 11 Oct 2007 15:24 Modified: 28 Oct 2007 5:49
Reporter: Patrick Ancillotti Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Stored Routines Severity:S4 (Feature request)
Version:5.1.22-rc OS:Linux
Assigned to: CPU Architecture:Any
Tags: event scheduler, events

[11 Oct 2007 15:24] Patrick Ancillotti
At the moment, we're unable to disable all events on a specified database, or even suspend them for a short while (possibly during maintainance) without having to alter each one separately (from my understanding) 

How to repeat:
Simply attempt to alter more than one at a go.

Suggested fix:
Possibly something like 'alter event <db>.%'?
[12 Oct 2007 8:57] Patrick Ancillotti
Forgot to set the OS to Linux.
[28 Oct 2007 5:49] Valeriy Kravchuk
Thank you for a reasonable feature request.