Switch to: V10V9V8V7V6V5

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;