Errors With Mysql Stored Function Creation Error 1064 & 1327

I am using MySQL v5.1.36 and I am trying to create a stored function using this code. DELIMITER // CREATE FUNCTION `modx`.getSTID (x VARCHAR(255)) RETURNS INT DETERMINISTIC BEG

Solution 1:

When creating a function/procedure from mysql console, the first command should be DELIMITER //. Otherwise, it uses default delimiter (;),

Solution 2:

I solved the my issues by adding `` around my variables. Here is the code I ended up with.

DELIMITER //CREATEFUNCTION `modx`.getSTID (x VARCHAR(255)) RETURNSINTDETERMINISTICBEGINDECLARE `y` INT;
    SELECT id INTO `y`
    FROM `modx`.coverage_state
    WHERE `coverage_state`.name = `x`;
    RETURN `y`;
    END//
DELIMITER ;