contains a row for each loadable function registered
automatically by a component or plugin, or manually by a
FUNCTION statement. For information about operations
that add or remove table rows, see
Section 5.7.1, “Installing and Uninstalling Loadable Functions”.
The name of the
stems from the terminology used at its inception for the
type of function now known as a loadable function (that is,
user-defined function, or UDF).
has these columns:
The function name as referred to in SQL statements. The value is
NULLif the function was registered by a
CREATE FUNCTIONstatement and is in the process of unloading.
The function return value type. The value is one of
The function type. The value is one of
The name of the library file containing the executable function code. The file is located in the directory named by the
plugin_dirsystem variable. The value is
NULLif the function was registered by a component or plugin rather than by a
The current function usage count. This is used to tell whether statements currently are accessing the function.
has these indexes:
Primary key on (
TRUNCATE TABLE is not permitted
mysql.func system table also lists
installed loadable functions, but only those installed using
lists loadable functions installed using
FUNCTION as well as loadable functions installed
automatically by components or plugins. This difference makes
mysql.func for checking which loadable
functions are installed.