Re: Begin..End not accepted in stored procedures/functions?

[Lee Wood]

The difference between the two versions (i.e. the one with BEGIN-END, and the one without) is that the former requires that you include ";" within the body of the stored function, which inadvertently ends the CREATE FUNCTION statement.

To get around this, you must temporarily change the delimiter to something else, and change it back to ";" after the function definition.
e.g.
DELIMITER $$
CREATE FUNCTION TESTFUNC( x INT )
RETURNS INT
DETERMINISTIC
BEGIN RETURN x+1;
END$$
DELIMITER ;