"how to delete all events in mysql" Code Answer

2

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

By Michael Sondergaard on June 6 2022

Answers related to “how to delete all events in mysql”

Only authorized users can answer the Search term. Please sign in first, or register a free account.