MySQL存储过程的问题

Question

存储过程
[code="sql"]
BEGIN
declare iLockedDrawed int;
declare iOutmanDrawed int;

SELECT `lockedDrawed`  INTO iLockedDrawed FROM `qb_award` WHERE `id`=awardId;
SET  iLockedDrawed = iLockedDrawed + 1;
UPDATE `qb_award` SET `lockedDrawed`=iLockedDrawed WHERE `id`=awardId;

SELECT `drawed` INTO iOutmanDrawed FROM `qb_award_outman` WHERE `awardId`=awardId AND `userId`=userId LIMIT 0,1;
SET  iOutmanDrawed =  iOutmanDrawed + 1;
UPDATE `qb_award_outman` SET `drawed`= iOutmanDrawed WHERE `awardId` = awardId AND `userId`=userId;

END
[/code]
参数是 userId varchar(255),awardId bigint

在单独执行
[code="sql"]
UPDATE qb_award_outman SET drawed= iOutmanDrawed WHERE awardId = 5 AND userId='AAA';
[/code]
这句的时候，能够正确执行
但是调用存储过程时，
[code="sql"]call qb_award_outman('AAA',5)[/code]
这条语句的执行会忽略WHERE部分，更新全表的drawed字段。。。。

请问各位，有人知道这是为什么呢？谢谢了。。。

Answer 1

应该是你分开写的那部分有问题，参数才传不进去。