SHOW FUNCTION CODE won't

Databases
1 
SHOW FUNCTION CODE add_feature_value_lang;

produces:


SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Am I missing something here? YES, the function is installed.

MySQL version 5.1.36

2

try this –

SHOW CREATE FUNCTION add_feature_value_lang
3

Thanks for that one. It says in the docs that to use SHOW FUNCTION CODE, you have to have mySQL compiled differently, this works great. However, I have found that HeidiSQL will show you the same information when you select a function or procedure in the list on the left.

4

neat, i can’t wait (actually, i can)

i have yet to try functions and procedures because my web host is still on 4.1

5

Remember, also, you must have SUPER privileges to install FUNCTIONS. Procedures can be installed by anyone. I don’t get that, for sure…