SHOW FUNCTION CODE add_feature_value_lang;
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
try this –
SHOW CREATE FUNCTION add_feature_value_lang
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.
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
Remember, also, you must have SUPER privileges to install FUNCTIONS. Procedures can be installed by anyone. I don’t get that, for sure…