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

Management and editing of MySQL and MariaDB procedures

The procedure editing module can be reached by selecting Procedures of the database in the main menu

MySQL - Managing and editing MySQL procedures

Module for managing and editing MySQL procedures in databases:

Procedures can be filtered alphabetically or by search.

Procedures can be selected for export or actions.

The list can be sorted by clicking on the column headings of the procedure list.

A backup archive is available.

Moreover, modules for editing the procedures and the output of scripts are available.

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

	Searching in procedure names, with %... inside the procedure names.
	Searching in SQL definitions of procedures.

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

Buttons in procedures list:

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

Icons in the procedures menu:

Displays the procedure creation script in the SQL editor.

Export and action module for selected procedures.

Creator:	The creator of the procedure is specified in the creation script.
Security type:	The security type of the procedure is specified in the creation script.
SQL data access:	The type of SQL data access of the procedure is specified in the creation script.
Comment:	The comment given for the procedure in the build script.

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

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

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

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

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

Creator:	The creator of the procedure is specified in the creation script.
Security type:	The security type of the procedure is specified in the creation script.
SQL data access:	The type of SQL data access of the procedure is specified in the creation script.
Comment:	The comment given for the procedure in the build script.

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

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

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

Labeled menu by double-clicking title bar.

MySQL and MariaDB Procedures are database objects that allow SQL statements to be grouped into a named block. They provide a way to encapsulate and execute a set of SQL statements as a single unit that can be called repeatedly with different parameters.

A procedure is created with the CREATE PROCEDURE statement, specifying a name for the procedure and defining the SQL statements that make up the body. Procedures can accept input parameters, so values can be passed to the procedure when it is called.

Variables can be declared within a procedure to store intermediate results or temporary values. Variables are preceded by the DECLARE keyword.

Procedures support control flow constructs such as loops (WHILE, LOOP), conditional statements (IF, CASE) and branches (GOTO, LEAVE).

Once a procedure has been created, it can be invoked using the CALL statement followed by the procedure name and any required arguments.

Stored procedures are often used for complex database operations, business logic implementation, data manipulation tasks, or repetitive tasks that require parameterization and reusability. They help improve code organization, maintainability, and performance by reducing the need to repeatedly submit SQL statements to the database server.

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

Updated: 2023-09-16

2020-2024 Heino Cunze-Fischer