The mysql.func table stores information about user-defined
functions (UDFs) created with the CREATE FUNCTION UDF
statement.
 
In MariaDB 10.4 and later, this table uses the Aria storage
engine.
 
MariaDB until 10.3
 
In MariaDB 10.3 and before, this table uses the MyISAM
storage engine.
 
The mysql.func table contains the following fields:
 
Field | Type | Null | Key | Default | Description | 
 
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 |
Type, 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
|
+------------------------------+-----+--------------+-----------+
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/mysqlfunc-table/