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

Management and editing of custom MySQL and MariaDB functions

The function editing module can be reached by selecting Functions of the database in the main menu

MySQL - Managing and editing MySQL functions

Module for managing and editing user-defined MySQL functions in databases:

Functions can be filtered alphabetically or by search.

Functions can be selected for export or actions.

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

A backup archive is available.

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

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

	Searching in function names, with %... inside the function names.
	Searching in SQL definitions of functions.

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

Buttons in functions list:

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

Icons in the functions menu:

Displays the function creation script in the SQL editor.

Export and action module for selected functions.

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

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

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

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

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

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

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

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

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

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

Labeled menu by double-clicking title bar.

MySQL and MariaDB functions are database objects that encapsulate a series of SQL statements and return a single value based on the input parameters. They provide a way to perform calculations, manipulate data, or retrieve information within a query or in a standalone manner.

MySQL and MariaDB provide a wide range of built-in functions for various purposes, including mathematical operations, string manipulations, date and time processing, data type conversions, aggregate functions, and more. These functions are part of the MySQL or MariaDB server and can be used directly in SQL statements.

MySQL and MariaDB also support user-defined functions, which can be used to create functions to perform specific operations that are not available through built-in functions.

Functions can be used in SQL statements, including SELECT, WHERE, HAVING, and ORDER BY clauses, as well as in expressions and calculations.

Functions help simplify complex operations, improve data retrieval, and enable efficient data processing within the database.

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

Updated: 2023-09-16

2020-2024 Heino Cunze-Fischer