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 '如果事件不存在,则会出现错误ERROR 1517 (HY000): Unknown event 'event_name
' results. 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
权限。