Spec-Zone .ru
спецификации, руководства, описания, API
|
MySQL 5.6 provides several SQL statements for working with scheduled events:
New events are defined using the CREATE EVENT
statement. See Section
13.1.11, "CREATE EVENT
Syntax".
The definition of an existing event can be changed by means of the ALTER EVENT
statement. See Section
13.1.2, "ALTER EVENT
Syntax".
When a scheduled event is no longer wanted or needed, it can be deleted from the
server by its definer using the DROP
EVENT
statement. See Section 13.1.22, "DROP EVENT
Syntax". Whether an event persists past the end of its
schedule also depends on its ON COMPLETION
clause, if it has one. See Section
13.1.11, "CREATE EVENT
Syntax".
An event can be dropped by any user having the EVENT
privilege for the database on which the event is defined. See
Section 19.4.6, "The Event Scheduler and
MySQL Privileges".