求大神 帮我看下这个存储过程哪里错了

Question

DROP PROCEDURE IF EXISTS Query_Role_PhoneRecord;
DELIMITER ;;
CREATE DEFINER=root@% PROCEDURE Query_Role_PhoneRecord(

in userId binary(16),
in pagNo int,
in pagSize int

)
BEGIN
declare bSize int;

set bSize=(pagNo-1)*pagSize;
if(bSize<0) then
set bSize =0; end if;
SELECT
view_role_phonerecord.ID,
view_role_phonerecord.LimId,
view_role_phonerecord.Recordor,
view_role_phonerecord.RecordTime,
view_role_phonerecord.BDID,
view_role_phonerecord.Caller,
view_role_phonerecord.PhonNo,
view_role_phonerecord.CallType,
view_role_phonerecord.Record,
view_role_phonerecord.IsRecordorActive
FROM cemscenter.view_role_phonerecord
where view_role_phonerecord.UserId=userId
limit bSize,pagSize;

END
;;
DELIMITER ;

[Err] 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 'bSize,pagSize;

END' at line 26

Answer 1

limit需要连接或者预编译
如

 PREPARE stmt1 FROM 'select * from users LIMIT ?,?'; 
SET @a = ino; 
SET @b = pagecount 
EXECUTE stmt1 USING @a, @b;
deallocate prepare stmt1; 

or 
set dd=conact('select * from users LIMIT',ino,pagecount) 
PREPARE stmt1 FROM dd 
EXECUTE stmt1
deallocate prepare stmt1;