删除mysql开始事件,如何删除MySQL中的所有事件

If I want to delete some event I need to query something like

"DROP EVENT IF EXISTS eventname"

But I can't find the command of deleting all the events at one time,must delete event one by one.

Is there some SQL of deleting all events at one time?

"DROP EVENT IF EXISTS (SELECT EVENT_NAME FROM information_schema.EVENTS)"

is not working either.

解决方案

sample one:

DELETE FROM mysql.event

WHERE db = 'myschema'

AND definer = 'jon@ghidora'

AND name = 'e_insert';

if you can delete the event with DROP EVENT IF EXISTS and re-add it with the new scheduled time.

To permanently delete an event yourself, you can use DROP EVENT:

DROP EVENT [IF EXISTS] event_name