	©	SQL :: Manager
				Home	Program Information	Technical details	Free download	Donate for a cup of coffee

Manage and edit MySQL and MariaDB events (EVENT)

The events managing module can be reached by selecting Events of the database in the main menu

MySQL - Managing and editing MySQL events

Module for managing and processing MySQL events:

Events can be filtered alphabetically or by search.

Events can be selected for export or actions.

The list can be sorted by clicking on the event list field headings.

A backup archive is available.

Moreover, modules for processing the events and the output of scripts are available.

	Reloads events menu and list.
	Displays the menu for alphabetical selection of events.
	Starts form for creating new events.

	Searching in event names, with %... inside the event names.
	Searching in SQL definitions of events.

	Displays the action module for selected events (Export, Save, Delete).
	Shows the export module for all events.
	Saves the creation scripts of all events to the archive.
	Shows the script archive.

Buttons in events list:

Edit:	Opens the form for editing MySQL events.
Script:	Displays the event creation script in the SQL editor.
Download:	Downloads the event creation script.
Delete:	Deletes the event.

Icons in the events menu:

Displays the event creation script in the SQL editor.

Export and action module for selected events.

Creator:	The creator of the event is specified in the creation script.

CREATE:	Creation option for event creation scripts: Event is created.
CREATE IF NOT EXISTS:	Create event if it doesn't exist.
DROP & CREATE:	Event will be deleted and re-created.
CREATE OR REPLACE:	Event is created or replaced. For MariaDB databases only.

Filename:	Filename for export files.
Delimiter:	Event program codes are enclosed in delimiters.
Append file name to individual files:	The specified file name is also included in the individual file export.
Database name in file names:	The database name is included in the file names.
Output single files with delimiters:	When exporting events to individual files, the program code is enclosed in delimiters.
GZIP compression:	Files are exported or backed up GZip compressed.

Show selected events as text:	The export file is shown as text in the SQL editor.
Download selected events in one file:	Only one export file will be downloaded with the specified name containing all scripts.
Download selected events as individual files:	A separate export file is downloaded for each event.

Save marked events:	Events are saved in the script archive of the MyWAY SQL Manager.
Delete marked events:	Events are deleted from the MySQL server (DROP).
Invert Selection:	Inverts the selection markers.

Export and backup module for all MySQL events of the database.

Creator:	The creator of the event is specified in the creation script.

CREATE:	Creation option for event creation scripts: Event is created.
CREATE IF NOT EXISTS:	Create event if it doesn't exist.
DROP & CREATE:	Event will be deleted and re-created.
CREATE OR REPLACE:	Event is created or replaced. For MariaDB databases only.

Filename:	Filename for export files.
Delimiter:	Event program codes are enclosed in delimiters.
Append file name to individual files:	The specified file name is also included in the individual file export.
Database name in file names:	The database name is included in the file names.
Output single files with delimiters:	When exporting events to individual files, the program code is enclosed in delimiters.
GZIP compression:	Files are exported or backed up GZip compressed.

Show all events as text:	The export file with all events is shown as text in the SQL editor.
Download all events in one file:	Only one export file will be downloaded with the specified name containing all scripts.
Download all events as individual files:	A separate export file is downloaded for each event.

Labeled menu by double-clicking title bar.

MySQL and MariaDB events are database objects that can be used to schedule and automate tasks to run at specific times or at specific intervals. They are similar to cron jobs in Unix-like operating systems.

Events can be scheduled to run once or repeatedly at specified intervals. The start time, the end time (optional) and the interval at which the event is to be executed can be defined. They consist of one or more SQL statements that define the actions to be taken when the event is executed. These statements may involve data manipulation, queries, or other database operations. They must be activated in order for them to run according to the specified schedule. They can also be deactivated or deleted when they are no longer needed.

Events are useful for automating maintenance tasks, generating reports, updating data regularly, or performing other recurring database operations.

The event scheduler in the MySQL or MariaDB server configuration must be enabled for events to work.

More information about MySQL events can be found here: mysql.com and mariadb.com

Updated: 2023-09-16

2020-2024 Heino Cunze-Fischer