When i am creating a user defined function in one of my mysql server, it's not creating any row in mysql.func table . Even though i have multiple functions in my mysql server , this table is empty . Can someone explain me why its not getting logged . it should create row like mysql.proc table right whenever we create any stored procedure. I am using mysql 5.5.40. Thanks in advance.
MySQL – No Records in Mysql.func Table Despite Stored Functions
functionsMySQLmysql-5.5stored-procedures
Related Question
- Sql-server – Error updating zoned field from SQL Server stored procedure linked server to iSeries
- Sql-server – How to create a SQL trigger to execute a stored procedure when a table is updated
- Mysql – ny way to perform atomic updates of stored procedures in MySQL
- SQL Server – CREATE and DROP TABLE Permissions in Stored Procedures
- Mysql – Non Super User cannot alter stored procedures and functions
- SSIS Data Source – Embedded Queries, Stored Procedures, or Functions
Best Answer
All stored procedures and stored functions, whose code is written in the MySQL Stored Procedure Language, reside in
mysql.proc
.You can see how many of each with this
The only time I have ever seen
mysql.func
is in context withAGGREGATE
functions:According to MySQL Documentation on
CREATE FUNCTION Syntax for User-Defined Functions
My guess is that
mysql.func
storesAGGREGATE
functions and not regular functions. Evidently, you would create some UDF in C/C++ and register it inmysql.func
using theCREATE AGGREGATE FUNCTION
syntax.