Table of Contents
DROP EVENT
The DROP EVENT statement stops the event immediately and deletes it completely from the server.
Syntax
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 the active database to 'masterdb', for this you need to use the SQL command “USE master;”
Examples
USE master; // not required since v9.7 DROP EVENT IF EXISTS backup_db1_24;