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 generate a NOTE
for non-existent events instead by using IF EXISTS
. See SHOW WARNINGS
.
This statement requires the EVENT
privilege. In MySQL 5.1.11 and earlier, an event could be dropped only by its definer, or by a user having the SUPER
privilege.
DROP EVENT myevent3;
Using the IF EXISTS clause:
DROP EVENT IF EXISTS myevent3; Query OK, 0 rows affected, 1 warning (0.01 sec) SHOW WARNINGS; +-------+------+-------------------------------+ | Level | Code | Message | +-------+------+-------------------------------+ | Note | 1305 | Event myevent3 does not exist | +-------+------+-------------------------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/drop-event/