The DROP EVENT statement is just like it sounds: the event immediately is stopped, and deleted completely from the server.
drop_event_statement : DROP EVENT [ IF EXISTS ] event_name
If event with the specified name is not found, then an error is not generated; in case
IF EXISTSis present, a warning still is generated.
- UP TO v9.7: before executing this command you must switch active database to be 'masterdb', for this you need use SQL command “USE master;”
USE master; // not required since v9.7 DROP EVENT IF EXISTS backup_db1_24;