Adding a manually-triggered event to a database

If you create an event handler without a schedule or system event to trigger it, it is executed only when manually triggered.

1. Connect to the database as a user with DBA authority.

2. Execute a CREATE EVENT statement with no schedule or WHERE clause. The restricted syntax of the CREATE EVENT is as follows:

   CREATE EVENT event-name
   HANDLER
   BEGIN
    ... event handler 
   END
   

If you are developing event handlers, you can add schedules or system events to control the triggering of an event later, using the ALTER EVENT statement.

See also: