MySQL 5.1.6 and later provides several SQL statements for working with scheduled events:
          New events are defined using the CREATE
          EVENT statement. See Section 12.1.11, “CREATE EVENT Syntax”.
        
          The definition of an existing event can be changed by means of
          the ALTER EVENT statement. See
          Section 12.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 12.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 12.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. Prior to MySQL 5.1.12,
          a user other than the definer required privileges on the
          mysql.event table. See
          Section 18.4.6, “The Event Scheduler and MySQL Privileges”.
        


User Comments
Add your own comment.