mysql - 找出此存储过程中的语法错误

Question

DELIMITER //
CREATE PROCEDURE compare (x INT,  y INT) RETURNS INT
BEGIN
    DECLARE test INT;

    IF x > y 
        THEN SET test = 1;
    ELSEIF y > x
        THEN SET test = -1;
    ELSE SET test = 0;

    END IF;

    RETURN test;
END
//

任何人都可以显示这里的错误是什么吗？ PhpMyAdmin 说

#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 'INT BEGIN DECLARE test INT; IF x > y THEN SET test = 1; ELSEIF y >' at line 1

Answer 1

您必须改为CREATE FUNCTION，因为过程不能返回任何东西，只有函数可以。