Event Syntax

MySQL 5.6 provides several SQL statements for working with scheduled events:

• New events are defined using the CREATE EVENT statement. See , "CREATE EVENT Syntax".
• The definition of an existing event can be changed by means of the ALTER EVENT statement. See , "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 , "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 , "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 , "The Event Scheduler and MariaDB Privileges".

Retornar