snippetMinor
How to drop all scheduler events in MySQL 5.6?
Viewed 0 times
schedulereventsalldropmysqlhow
Problem
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?
Solution
you can disable them via the following command:
or dropping them one by one using the command:
set GLOBAL event_scheduler=0;or dropping them one by one using the command:
DROP EVENT [IF EXISTS] event_name;Code Snippets
set GLOBAL event_scheduler=0;DROP EVENT [IF EXISTS] event_name;Context
StackExchange Database Administrators Q#45636, answer score: 2
Revisions (0)
No revisions yet.