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.
- Before execute this command you must switch active database to be masterdb, for this you need use SQL command “USE master;”
// We must activate master database first of all. USE master; DROP EVENT IF EXISTS backup_db1_24;