Enable/disable a mysql event

Hello everybody,

Is it possible de enable or disable a mysql event using a python script ?

When I press a button I want to execute the following request : “ALTER EVENT myevent DISABLE”

Thanks,

Sure. Although it doesn’t say so, the system.db.runUpdateQuery() function can be used for any SQL statement that doesn’t return a rows result set. So you can use a standard button, and put something like the following in the ‘actionPerformed’ event:system.db.runUpdateQuery('ALTER EVENT myevent DISABLE')