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,
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')