Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 29.5Mb
PDF (A4) - 29.5Mb
PDF (RPM) - 28.1Mb
HTML Download (TGZ) - 7.1Mb
HTML Download (Zip) - 7.1Mb
HTML Download (RPM) - 6.1Mb
Man Pages (TGZ) - 190.3Kb
Man Pages (Zip) - 305.1Kb
Info (Gzip) - 2.8Mb
Info (Zip) - 2.8Mb
Excerpts from this Manual

MySQL 5.6 Reference Manual  /  ...  /  Obtaining Information About Loadable Functions

5.6.2 Obtaining Information About Loadable Functions

The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION:

SELECT * FROM mysql.func;

The func table has these columns:

  • name

    The function name as referred to in SQL statements.

  • ret

    The function return value type. Permitted values are 0 (STRING), 1 (REAL), 2 (INTEGER), 3 (ROW), or 4 (DECIMAL).

  • dl

    The name of the function library file containing the executable function code. The file is located in the directory named by the plugin_dir system variable.

  • type

    The function type, either function (scalar) or aggregate.