根据mysql文档描述,存储过程和存储函数的定义都在INFORMATION_SCHEMA.ROUTINES中保存,但是user-defined functions (UDFs)除外。
那么UDFs是保存在哪里呢?
答案是:mysql.func中。
mysql> desc mysql.func;
+-------+------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+------------------------------+------+-----+---------+-------+
| name | char(64) | NO | PRI | | |
| ret | tinyint(1) | NO | | 0 | |
| dl | char(128) | NO | | | |
| type | enum('function','aggregate') | NO | | NULL | |
+-------+------------------------------+------+-----+---------+-------+
4 rows in set (0.02 sec)
mysql>
更多请参考:http://blog.csdn.net/luoqiya/article/details/12888553