26.12.18.6 The user_defined_functions Table

Contents

The user_defined_functions table contains a row for each user-defined function (UDF) registered by a server component or plugin, or by a CREATE FUNCTION statement.

user_defined_functions has these columns:

UDF_NAME
The UDF name as referred to in SQL statements. The value is NULL if the function was registered by a CREATE FUNCTION statement and is in the process of unloading.
UDF_RETURN_TYPE
The UDF return value type. The value is one of int, decimal, real, char, or row.
UDF_TYPE
The UDF type. The value is one of function (scalar) or aggregate.
UDF_LIBRARY
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. The value is NULL if the UDF was registered using a server component service rather than by a CREATE FUNCTION statement.
UDF_USAGE_COUNT
The current UDF usage count.

The user_defined_functions table has these indexes:

Primary key on (UDF_NAME)

TRUNCATE TABLE is not permitted for the user_defined_functions table.

Find a PHP function

Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-user-defined-functions-table.html

The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.

References

Manuel MySQL : https://dev.mysql.com/

These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.

Contents Haut