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.
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(). |
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 | +------------------------------+-----+--------------+-----------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/mysqlfunc-table/