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