create function mysql error

Question

Here is my function

DELIMITER //
CREATE FUNCTION specialUser(user INT) RETURNS user_id INT
BEGIN
    DECLARE user_id INT DEFAULT 0;
    CASE 
     WHEN user = 1556 THEN SET user_id = 1001;
     WHEN user = 1018 THEN SET user_id = 1002;
     WHEN user = 3658 THEN SET user_id = 1003;
         ELSE SET user_id = user;
    END CASE;
 RETURN user_id;
END//

I get error:

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 'user_id INT BEGIN DECLARE user_id INT DEFAULT 0; CASE ' at line 1

AndreKR · Accepted Answer · 2010-11-30 12:57:07Z

3

You can only state the type of the result, there's no use in giving an identifier, so:

CREATE FUNCTION specialUser(user INT) RETURNS INT

instead of

CREATE FUNCTION specialUser(user INT) RETURNS user_id INT

answered Nov 30, 2010 at 12:57

AndreKR

34k21 gold badges120 silver badges181 bronze badges

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

Collectives™ on Stack Overflow

create function mysql 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