MySQL query - weird syntax error

Question

I'm using phpmyadmin and MySQL to run a simple query, that creates a function checking the existence of a certain record. It keeps throwing a syntax error at line 7 with Declare. I have no idea why. I did try to use the built-in function creator, but it's messed up and I don't like it. Any help appreciated!

CREATE FUNCTION  check_if_card_exists (_name TEXT)
RETURNS INT
DETERMINISTIC
READS SQL DATA

    BEGIN
    DECLARE res INT; --line 7
    IF EXISTS (SELECT `name` FROM `cards` WHERE `name` = _name)
    THEN SET res = 1;
    ELSE SET res = 0;
    END IF;
    RETURN res;
    END

Orel Eraki · Accepted Answer · 2014-03-29 11:31:07Z

1

Try the following:

DELIMITER $$
DROP FUNCTION IF EXISTS `check_if_card_exists`$$

CREATE FUNCTION  check_if_card_exists (_name TEXT)
RETURNS INT
DETERMINISTIC
READS SQL DATA

    BEGIN
    DECLARE res INT; --line 7
    IF EXISTS (SELECT `name` FROM `cards` WHERE `name` = _name)
    THEN SET res = 1;
    ELSE SET res = 0;
    END IF;
    RETURN res;
    END$$

DELIMITER ;

answered Mar 29, 2014 at 11:31

Orel Eraki

12.2k4 gold badges31 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL query - weird syntax error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related