MySQL 5.5 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.18 DROP EVENT Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER EVENT Syntax
- 12.1.3 ALTER FUNCTION Syntax
- 12.1.4 ALTER PROCEDURE Syntax
- 12.1.5 ALTER SERVER Syntax
- 12.1.6 ALTER TABLE Syntax
- 12.1.7 ALTER VIEW Syntax
- 12.1.8 CREATE DATABASE Syntax
- 12.1.9 CREATE EVENT Syntax
- 12.1.10 CREATE FUNCTION Syntax
- 12.1.11 CREATE INDEX Syntax
- 12.1.12 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.13 CREATE SERVER Syntax
- 12.1.14 CREATE TABLE Syntax
- 12.1.15 CREATE TRIGGER Syntax
- 12.1.16 CREATE VIEW Syntax
- 12.1.17 DROP DATABASE Syntax
- 12.1.18 DROP EVENT Syntax
- 12.1.19 DROP FUNCTION Syntax
- 12.1.20 DROP INDEX Syntax
- 12.1.21 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.22 DROP SERVER Syntax
- 12.1.23 DROP TABLE Syntax
- 12.1.24 DROP TRIGGER Syntax
- 12.1.25 DROP VIEW Syntax
- 12.1.26 RENAME TABLE 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 generate a warning
for nonexistent events instead using IF EXISTS.
This statement requires the EVENT
privilege for the schema to which the event to be dropped belongs.
User Comments
Add your own comment.