问创建MySQL过程错误

EN

CREATE PROCEDURE pr_update_vote (IN pCid INT, IN pVote INT, IN pMid INT, OUT pNewVote INT)
BEGIN
    DECLARE vMid, vVote, vCurrentVote, vNewVote INT;

    IF pVote = 1 THEN
        SET vVote = 1;
    ELSE
        SET vVote = -1;
    END IF;

    SELECT vMid = `mid`, vCurrentVote = vote FROM td_voted WHERE id = pCid LIMIT 1;

    IF vMid <> pMid THEN
        SELECT vVoteType = vote 
        FROM td_votes 
        WHERE `mid` = vMid 
        AND cid = pCid 
        LIMIT 1;

        IF (vVoteType IS NOT NULL) OR (vVoteType <> vVote) THEN
            UPDATE td_votes 
            SET vote = vVote, 
            updated = NOW()
            WHERE cid = pCid
            AND `mid` = pMid
            LIMIT 1;
        ELSE
            INSERT INTO td_votes (`mid`, cid, vote)
            VALUES (pMid, pCid, vVote);
        END IF;

        SET vNewVote = vCurrentVote + vVote;

        UPDATE td_voted
        SET vote = vNewVote
        WHERE id = pCid
        LIMIT 1;

        SELECT pNewVote = vote FROM td_voted WHERE id = pCid LIMIT 1;
    END IF;
END