The mysql.func table stores information about user-defined functions (UDFs) created with the CREATE FUNCTION UDF statement.

It contains the following fields:

FieldTypeNullKeyDefaultDescription
namechar(64)NOPRIUDF name
rettinyint(1)NO0
dlchar(128)NOShared library name
typeenum('function','aggregate')NONULLType, either function or aggregate. Aggregate functions are summary functions such as SUM() and AVG().

Example

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  |
+------------------------------+-----+--------------+-----------+

Comments

Comments loading...