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

Manage and edit MariaDB Packages

The package editing module can be reached by selecting Packages of the database in the main menu

Module for managing and editing MariaDB packages in databases:

Packages can be filtered alphabetically or by search.

Packages can be selected for export or actions.

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

A backup archive is available.

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

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

	Searching in package names, with %... inside the package names.
	Searching in SQL definitions of packages.

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

Buttons in packages list:

Edit:	Opens the form for editing MariaDB packages.
Script:	Displays the package creation script in the SQL editor.
Download:	Downloads the package build script.
Delete:	Deletes the package.

Icons in the packages menu:

Displays the package creation script in the SQL editor.

Export and action module for selected packages.

Creator:	The creator of the package is specified in the build script.
Security type:	The security type of the package is specified in the build script.
Comment:	The comment given about the package in the build script.

CREATE:	Creation option for package creation scripts: package is created.
CREATE IF NOT EXISTS:	Create a package if it doesn't exist.
DROP & CREATE:	Package will be deleted and recreated.
CREATE OR REPLACE:	Create or replace package.

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

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

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

Export and backup module for all MariaDB database packages.

Creator:	The creator of the package is specified in the build script.
Security type:	The security type of the package is specified in the build script.
Comment:	The comment given about the package in the build script.

CREATE:	Creation option for package creation scripts: package is created.
CREATE IF NOT EXISTS:	Create a package if it doesn't exist.
DROP & CREATE:	Package will be deleted and recreated.
CREATE OR REPLACE:	Create or replace package.

Filename:	Filename for export files.
Delimiter:	Package 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 individual files with delimiters:	When exporting packages to individual files, the program code is enclosed in delimiters.
GZIP compression:	Files are exported or backed up GZip compressed.

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

Labeled menu by double-clicking title bar.

MariaDB Packages are collections of stored procedures and functions that can be installed on databases. They contain SQL code that can be executed in a database.

In MariaDB, creating a package involves defining a set of procedures and functions, which may be logically or thematically related, and grouping them into a single package. The procedures and functions contained in the package can be called like any other stored routine by prefixing the package name with a period. MariaDB packages can also contain non-public procedures and functions that can only be called from routines within the package. A package can also contain local variables and internally executable code.

MariaDB packages provide a convenient way to consolidate, organize and share code between different databases and can help simplify database administration. The MariaDB server must be switched to Oracle mode for creating, editing and calling routines in packages. This can also be done temporarily by setting the system variable sql_mode=Oracle.

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

Updated: 2023-09-16

2020-2024 Heino Cunze-Fischer