Switch to: V9V8V7V6V5

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;