Events are being implemented in the 5.1.16 version of MySQL
Server. MySQL Events are tasks that run according to a schedule.
Therefore, we sometimes refer to them as scheduled events.
When you create an event, you are creating a named database
object containing one or more SQL statements to be executed
at one or more regular intervals, beginning and ending at
a specific date and time. Conceptually, this is similar to
the idea of the Unix crontab or the Windows Task Scheduler.
Create a Event
To create a event:
- Click the
Event button in the main window
- Press the
New Event button
- Edit event properties on the appropriate tabs.
Design a Event
To design a event:
- Select the event you want to design.
- Click the
Design Event button.
- Edit event properties on the appropriate tabs.
Delete a Event
To delete a event:
- Select the event you want to design.
- Click the
Delete Event button.
- Confirm deleting in the dialog window.
|