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

Editing custom MySQL and MariaDB functions using SQL Editor

Editing MySQL functions is part of the functions management

Module for editing MySQL functions:

You can search and mark in the SQL editor.

Functions can be run for testing.

Available are archiving and download.

	Saves the changes to the function to the database. A security copy of the previous version is stored in the script archive.
	Testing the function with parameter input and displaying the result.
	View and edit permissions of the function.
	Saves the function in the script archive.
	Download the function creation script.
	Deletes function from database.

Searching in SQL Editor:

	Find and highlight terms in the SQL Editor.
	Delete search markers.
	Jump to previous marker.
	Jump to next marker.

Function head:

Name:

Name of the function.

Type:

procedure or function.

Parameter:

Parameter list of the function.

Name:	Name of the parameter.
Type:	Data type of the parameter.
Length / Value:	Data type length or values.
Option:	Variable options according to type.

Return:

Result definition of the function.

Type:	Data type of the return value.
Length / Value:	Data type length or values.
Option:	Value option according to the return type.

Function options:

Scheduled:

Specifies whether the function is plan-driven.

Creator:

Creator of the function.

Security type:

Selection of the security-its-type of the function.

SQL data access:

Data access selection .

Comment:

Selection of check option.

Save settings:

Save the function options.

	Add parameter to function at position.
	Delete parameter from function.
	Move parameter up.
	Move parameter down.

Labeled menu by double-clicking title bar.

Learn more about editing SQL scripts: SQL-Editor
More information about MySQL functions and procedures can be found here: mysql.com and mariadb.com

Updated: 2023-09-16

2020-2024 Heino Cunze-Fischer