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

Manage and edit MySQL and MariaDB triggers

The trigger editing module can be reached by selecting Trigger of the database in the main menu

MySQL - Managing and editing MySQL triggers

Module for managing and editing MySQL triggers:

Triggers can be filtered alphabetically or by search.

Triggers can be selected for export or actions.

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

A backup archive is available.

Moreover, there are modules for editing triggers and output of scripts.

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

	Searching in trigger names, with %... inside the trigger names.
	Searching in SQL definitions of triggers.

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

Buttons in triggers list:

Edit:	Opens the form for editing MySQL triggers.
Script:	Shows the creation script of the trigger in the SQL editor.
Download:	Downloads the trigger creation script.
Delete:	Deletes the trigger.

Icons in the triggers menu:

Displays the trigger creation script in the SQL editor.

Export and action module for selected triggers.

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

CREATE:	Create option for trigger creation scripts: Trigger is created.
CREATE IF NOT EXISTS:	Create a trigger if it doesn't exist.
DROP & CREATE:	Trigger is deleted and recreated.
CREATE OR REPLACE:	Trigger is created or replaced. For MariaDB databases only.

Filename:	Filename for export files.
Delimiter:	Program codes of the triggers 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 triggers to individual files, the program code is enclosed in delimiters.
GZIP compression:	Files are exported or backed up GZip compressed.

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

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

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

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

CREATE:	Create option for trigger creation scripts: Trigger is created.
CREATE IF NOT EXISTS:	Create a trigger if it doesn't exist.
DROP & CREATE:	Trigger is deleted and recreated.
CREATE OR REPLACE:	Trigger is created or replaced. For MariaDB databases only.

Filename:	Filename for export files.
Delimiter:	Program codes of the triggers 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 triggers to individual files, the program code is enclosed in delimiters.
GZIP compression:	Files are exported or backed up GZip compressed.

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

Labeled menu by double-clicking title bar.

MySQL and MariaDB Triggers are database objects that run automatically in response to certain events, such as inserting, updating, or deleting data in a table . They run either before or after the event occurs, and they are associated with a specific table.

They are defined to respond to INSERT, UPDATE, or DELETE events in a table react and are activated automatically when the associated event occurs in the table.

The body of a trigger consists of SQL statements that define the actions to be taken when the trigger fires. This can include changing data in the same or different tables, throwing errors, or performing additional checks. The predefined variables OLD and NEW can be used to access the old and new values of the rows concerned. These variables are used to refer to the values before and after the event.
Multiple triggers can be defined for a single event in a table. The order of execution can be specified.

Triggers are useful for enforcing data integrity, monitoring changes, logging events, or executing complex business logic that needs to be executed automatically based on specific database events.

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

Updated: 2023-09-16

2020-2024 Heino Cunze-Fischer