5.6.3 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) oraggregate
.