Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 31.4Mb
PDF (A4) - 31.5Mb
PDF (RPM) - 29.8Mb
HTML Download (TGZ) - 7.5Mb
HTML Download (Zip) - 7.5Mb
HTML Download (RPM) - 6.5Mb
Man Pages (TGZ) - 177.2Kb
Man Pages (Zip) - 287.5Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb
Excerpts from this Manual

MySQL 5.6 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.