Adding new functions
New functions can be added with any of the three supported types in MySQL 8. Each of the types have their own advantages and disadvantages. Where and which type of function should be added or implemented depends on the requirements of the function.
The following is the list of the supported three types of new function in MySQL 8, which we will look at in the following section:
- Adding a function through the user-defined function interface.
- Adding a function as a native (built-in) MySQL function.
- Adding a function by creating a stored function.
Features of a user-defined function interface
A user-defined function interface provides independent capabilities to a user purpose function.
The following features and capabilities are provided by the MySQL interface for user-defined functions:
- Functions can accept arguments of integer, string, or real values and can return values for the same types
- Simple functions can be defined to operate on a single row at a time or it can be aggregate...
