create function in mysql 5.0.26-3

I am trying to create a stored function. From the docs I saw the code for this function: CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!'); The version from the docs did not contain the DETERMINISTIC keyword. I added because it would not compile.

Re: create function in mysql 5.0.26-3

Anakreon Mejdi wrote: I am trying to create a stored function. From the docs I saw the code for this function: CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) DETERMINISTIC RETURN CONCAT('Hello, ',s,'!'); The version from the docs did not contain the DETERMINISTIC keyword. I added