I'm running "MySQL 4.0.23-standard", and trying to create a stored function.
Am I doing something wrong, or can I not create a stored function in 4.0.23?
What I want is a stored function to take an int from a column and alter it
(mask off the low 16-bits).
CREATE FUNCTION hello(
s CHAR( 20 )
) RETURNS CHAR( 50 ) RETURN CONCAT( 'Hello, ', s, '!' )
#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
'( s CHAR( 20 ) ) RETURNS CHAR( 50 ) RETURN CONCAT( 'Hello,