>>>> 2013/03/25 11:28 +0200, Dotan Cohen >>>> Thanks. I don't have the admin or root privileges on this database. Is that the only way to see the code behind the function? <<<<<<<< Well, you showed us "DEFINER: admin@localhost" for the function; here is a snippet from MySQL help about " SHOW CREATE FUNCTION func_name ":
... require that you be the owner of the routine or have <file:///C:/Program%20Files/MySQL/MySQL%20Server%205.5/HELP/sql-syntax.html#select>SELECT access to the mysql.proc table. If you do not have privileges for the routine itself, the value displayed for the Create Procedure or Create Function field will be NULL. I guess you have to find Admin (or Root) in real life to talk about the function. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
