DROP EVENT [IF EXISTS] event_name
此语句删除名为 event_name 的事件。该事件会立即停止激活,并从服务器中完全删除。This statement drops the event named
event_name. The event immediately
ceases being active, and is deleted completely from the server.
如果事件不存在,会出现错误 ERROR 1517 (HY000): Unknown event 'event_name'。你可以使用 IF EXISTS 来覆盖此行为,使语句对不存在的事件生成警告而不是错误。If the event does not exist, the error ERROR 1517
(HY000): Unknown event
'event_name' results. You
can override this and cause the statement to generate a warning
for nonexistent events instead using IF EXISTS.
此语句要求被删除事件所属模式具有 EVENT 权限。This statement requires the EVENT
privilege for the schema to which the event to be dropped belongs.