Question

I am trying to nest an if statement in what will eventually become a routine.

SET @foo = (SELECT foo FROM table WHERE id = 1);
SET @bar = (SELECT bar FROM table WHERE id = 1);

IF @foo = @bar THEN SET @thisVar = 1;
ELSE SET @thisVar = 0;
END IF

SELECT @thisVar;

但我得到:

Error Code: 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 IF @foo = @bar THEN SET @thisVar = 1; at line 1)

我做了什么错误?

Answer 1

确切地说,错误为什么说行不通。 1 ? 也许问题是,你实际上没有执行整个程序。

您可以尝试利用国际红十字与红新月联会的类似职能:

SET @thisVar = IF(@foo = @bar, 1, 0);

我认为,如果任务完成,就更短和更清洁。

Answer 2

当宣布所有程序时,打入程序似乎是罚款的。还删除了@s.

CREATE PROCEDURE `DO_SOMETHING`()
BEGIN
    DECLARE _foo VARCHAR(20);
    DECLARE _bar VARCHAR(20);
    DECLARE _thisVar INT;

    SET _foo =  test ;
    SET _bar =  test ;

    IF _foo = _bar THEN SET _thisVar = 1;
    ELSE SET _thisVar = 0;
    END IF;

    SELECT _thisVar;
END

友情链接