How to fix MySQL CREATE FUNCTION query?

Question

I want to add mysql function:

CREATE FUNCTION `chf_get_translation`(translation_id INT, site_lang INT) 
RETURNS text CHARSET utf8
BEGIN

  DECLARE translation TEXT;

  SELECT title 
    INTO translation 
    FROM chf_translations 
   WHERE key_id = translation_id 
     AND lang_id = site_lang;

  RETURN translation;

END

But get 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 3

What can be wrong with this function?

Answer 1

Try...

DELIMITER $$

CREATE FUNCTION chf_get_translation(translation_id INT, site_lang INT) RETURNS text CHARSET utf8 BEGIN

DECLARE translation TEXT;

SELECT title INTO translation FROM chf_translations WHERE key_id = translation_id AND lang_id = site_lang;

RETURN translation;

END$$