MySQL Syntax Error In Variable Declaration

Question

I have the following MySQL query:

DELIMITER //
CREATE PROCEDURE InsertResult (IN winnerID INT, IN loserID INT)
BEGIN
    INSERT INTO KomperResult (WinnerID, LoserID) VALUES (@winnerID, @loserID);
    DECLARE winnerScore, loserScore INT;
    SELECT Score INTO @winnerScore FROM KomperPerson WHERE ID = @winnerID;
    SELECT Score INTO @loserScore FROM KomperPerson WHERE ID = @loserID;
    IF (@loserScore >= @winnerScore) THEN UPDATE KomperPerson SET Score = @loserScore + 1 WHERE ID = @winnerID; END IF;
END//

I get an error on:

DECLARE winnerScore, loserScore INT;

What am I doing wrong?

The Scrum Meister · Accepted Answer · 2011-02-22 20:32:16Z

6

DECLAREs need to go on the first line of your procedure.

From the docs:

DECLARE is permitted only inside a BEGIN ... END compound statement and must be at its start, before any other statements.

answered Feb 22, 2011 at 20:32

The Scrum Meister

30.2k8 gold badges69 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

MySQL Syntax Error In Variable Declaration

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