Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 39.4Mb
PDF (A4) - 39.4Mb
PDF (RPM) - 38.7Mb
HTML Download (TGZ) - 11.1Mb
HTML Download (Zip) - 11.1Mb
HTML Download (RPM) - 9.8Mb
Man Pages (TGZ) - 213.7Kb
Man Pages (Zip) - 322.9Kb
Info (Gzip) - 3.6Mb
Info (Zip) - 3.6Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  Obtaining User-Defined Function Information

5.6.2 Obtaining User-Defined Function Information

The func table in the mysql system database shows which UDFs have been registered with CREATE FUNCTION:

SELECT * FROM mysql.func;

The func table has these columns:

  • name

    The UDF name as referred to in SQL statements.

  • ret

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

  • dl

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

  • type

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


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.