13.1.25 DROP EVENT Statement语句

DROP EVENT [IF EXISTS] event_name

This statement drops the event named event_name. 此语句删除名为event_name的事件。The event immediately ceases being active, and is deleted completely from the server.事件立即停止活动,并从服务器中完全删除。

If the event does not exist, the error ERROR 1517 (HY000): Unknown event 'event_name' results. 如果事件不存在,则会出现错误ERROR 1517 (HY000): Unknown event 'event_name'You can override this and cause the statement to generate a warning for nonexistent events instead using IF EXISTS.您可以重写它,并使语句为不存在的事件生成警告,而不是使用IF EXISTS

This statement requires the EVENT privilege for the schema to which the event to be dropped belongs.此语句要求要删除的事件所属的架构具有EVENT权限。