How to delete all events in MySQL

database, mysql, sql

Solution

sample one:

DELETE FROM mysql.event
    WHERE db = 'myschema'
      AND definer = 'jon@ghidora'
      AND name = 'e_insert';

https://dev.mysql.com/doc/refman/5.1/en/events-privileges.html

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

https://dev.mysql.com/doc/refman/5.1/en/drop-event.html

Problem

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.

Original source