Quick Start
Connect to MySQL
HTTP Tunnel
SSH Tunnel
Databases
Tables
Adding Fields and Choosing Data Types
Customising Fields
Primary Keys and Indexes
Filter Wizard
Foreign Keys
Foreign Keys Data Selection
Triggers
Import/Export
Queries
Visual Query Builder
Stored Procedure
View
Event
Data
Manage Users
Privileges Provided by MySQL
User Editor
Backup
Data Transfer
Schedule
Server Monitor
Data Synchronization
Structure Synchronization
Console
Virtual Grouping
Maintaining your databases/tables
Preferences
General
Tabs
Tables
Queries
  Working with Event
 

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:

  1. Click the Event button in the main window
  2. Press the New Event button
  3. Edit event properties on the appropriate tabs.

Design a Event

To design a event:

  1. Select the event you want to design.
  2. Click the Design Event button.
  3. Edit event properties on the appropriate tabs.

Delete a Event

To delete a event:

  1. Select the event you want to design.
  2. Click the Delete Event button.
  3. Confirm deleting in the dialog window.