|Previous Top Next|
When creating a new Event in the editor, you can name your event for easier reference.
The Event type box has two choices: Recurring or Run Once. The sections below the Preserve checkbox will be enabled or disabled depending on the choice in this box.
MySQL Event Editor
For a Run Once event, you need to specify a date and time at which it should run and enter SQL to be executed.
A Recurring event can be more complex with regard to when it runs. You can specify the optional start and optional end date time values and an interval. Database Workbench comes with a set of predefined intervals that might be of use to you.
See also: Date and Time Editing