The mysql.func table registers user-defined functions (UDFs), storing their names and the shared library files containing their code.
The mysql.func table stores information about user-defined functions (UDFs) created with the CREATE FUNCTION UDF statement.
This table uses the Aria storage engine.
The mysql.func table contains the following fields:
This page is licensed: CC BY-SA / Gnu FDL
name
char(64)
NO
PRI
UDF name
ret
tinyint(1)
NO
0
dl
char(128)
NO
Shared library name
type
enum('function','aggregate')
NO
NULL
SELECT * FROM mysql.func;
+------------------------------+-----+--------------+-----------+
| name | ret | dl | type |
+------------------------------+-----+--------------+-----------+
| spider_direct_sql | 2 | ha_spider.so | function |
| spider_bg_direct_sql | 2 | ha_spider.so | aggregate |
| spider_ping_table | 2 | ha_spider.so | function |
| spider_copy_tables | 2 | ha_spider.so | function |
| spider_flush_table_mon_cache | 2 | ha_spider.so | function |
+------------------------------+-----+--------------+-----------+