Navicat - create event for MySQL Windows - Create, Edit and Delete Event

MySQL Event Scheduler was added in MySQL 5.1.6. 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 Windows Task Scheduler.

Just sample click to open an object pane for Event. A right-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected event.

Create Event

To create a new event

Select anywhere on the object pane.
Click the New Event from the object pane toolbar.
or
Right-click and select New Event from the popup menu.
Edit event properties on the appropriate tabs of the Event Designer.

Hint: To create new event you can also right-click the Event node of the navigation pane and select the New Event from the popup menu.

To create a new event with the same properties as one of the existing event has (using drag and drop method)

Apply to: current database {same connection}

Select the event(s) for copying in the navigation pane/object pane.

Right-click and drag the chosen event(s) to the target location.

Select one of the following options:

Copy here (Structure and Data)

Copy here (Structure only)

Move here

Cancel

The newly created event(s) will be named as "eventname_copy".

Apply to: different database {same connection}

different database {different connection} (Data Transfer tool will be activated)

Select the event(s) for copying in the object pane.

Drag and drop the chosen event(s) to the target database.

Select one of the following options:

Copy here (Structure and Data)

Copy here (Structure only)

Cancel

To create a new event with modification as one of the existing event

Select the event for modifying in the navigation pane/object pane.
Right-click and select the Design Event from the popup menu or simply double-click the event.
or
Click the Design Event from the object pane toolbar.
Modify event properties on the appropriate tabs of the Event Designer.
Click Save As.

Edit Event

To edit the existing event (manage its definition etc)

Select the event for editing in the navigation pane/object pane.
Right-click and select the Design Event from the popup menu or simply double-click the event.
or
Click the Design Event from the object pane toolbar.
Edit event properties on the appropriate tabs of the Event Designer.

To change the name of the event

Select the event for editing in the navigation pane/object pane.
Right-click and select the Rename from the popup menu.

Delete Event

To delete an event

Select the event for deleting in the navigation pane/object pane.
Right-click and select the Delete Event from the popup menu.
or
Click the Delete Event from the object pane toolbar.
Confirm deleting in the dialog window.

Achieve Event Information

To achieve an event information (event repeat type, status, definer and DDL, etc)

Select the event in the navigation pane/object pane.
Right-click the selected event and choose Event Information from the popup menu.