MySQL 5.1 リファレンスマニュアル :: 19 Event Scheduler :: 19.2 Event Scheduler Syntax :: 19.2.3 DROP EVENT Syntax
Section Navigation [Toggle]
- 19.2 Event Scheduler Syntax
- 19.2.1 CREATE EVENT Syntax
- 19.2.2 ALTER EVENT Syntax
- 19.2.3 DROP EVENT Syntax
DROP EVENT [IF EXISTS] event_name
This statement drops the event named
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. You
can override this and cause the statement to fail silently by
using IF EXISTS.
Beginning with MySQL 5.1.12, an event can be dropped by any user
having the EVENT privilege on the database
schema to which the event to be dropped belongs. (In MySQL
5.1.11 and earlier, an event could be dropped only by its
definer, or by a user having the SUPER
privilege.)
