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.
