In MySQL 5.6 is there a way to drop all scheduler events with an administrative command or do I have to go through them one by one with DROP EVENT [IF EXISTS] event_name?
1 Answer
you can disable them via the following command:
set GLOBAL event_scheduler=0;
or dropping them one by one using the command:
DROP EVENT [IF EXISTS] event_name;
INFORMATION_SCHEMA
.EVENTS
table to gather all the active events and then construct and run theDROP EVENT
statements.