Table of Contents
DROP EVENT
The DROP EVENT statement is just like it sounds: the event immediately is stopped, and deleted completely from the server.
Syntax
drop_event_statement
: DROP EVENT [ IF EXISTS ] event_name
Arguments
[IF EXISTS]
If event with the specified name is not found, then an error is not generated; in case IF EXISTS is present, a warning still is generated.
Notes
- 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;”
Examples
USE master; // not required since v9.7 DROP EVENT IF EXISTS backup_db1_24;