©
SQL :: Manager
Home
Program Information
Technical details
Free download
Donate for a cup of coffee
Installation & program start
Program structure
System administration
User settings
MySQL Server
MySQL Databases
MySQL Tables
MySQL Partitions
System-versioned tables
MariaDB Sequences
MySQL Views
MySQL Procedures
MySQL Functions
Create functions
Editing functions
Testing functions
MySQL function reference
Numeric functions
String functions
Regular expressions
Date and Time functions
Comparison functions
Encryption and Compression
Conversion functions
NULL functions
Aggregate functions
Window functions
JSON functions
Geometric functions
Sequence functions
Information functions
Dynamic Columns functions
Miscellaneous functions
MariaDB Packages
MySQL Triggers
MySQL Events
SQL statements
Creating MySQL and MariaDB functions (CREATE FUNCTION)
Creating of MySQL functions is part of the functions management
Module for creating MySQL functions:
You can search and mark in the SQL editor.
Saves the function to the 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.
Add parameter to function at position.
Delete parameter from function.
Move parameter up.
Move parameter down.
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
Imprint
Contact
Terms & conditions
Privacy & Cookies
Updates
Sitemap
©
2020-2024 Heino Cunze-Fischer