Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
1  
I think you have to use the INFORMATION_SCHEMA.EVENTS table to gather all the active events and then construct and run the DROP EVENT statements. –  ypercube Jul 3 '13 at 8:28
    
It looks like this is the only way, so it's scripting time. Thanks –  Lefteris Koutsoloukas Jul 3 '13 at 8:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.