日期:2014-05-18 浏览次数:20574 次
CREATE PROCEDURE PROC_NAME(IN a INT, IN bINT)
BEGIN
DECLARE sql1VARCHAR(100);
SET sql1 ="SELECT*FROM uw_player_skill LIMIT ?,?";
SET@fvar =a;
SET@svar =b;
SET@SQUERY =sql1;
PREPARE STMTFROM @SQUERY;
EXECUTE STMTUSING @fvar,@svar;
END
------解决方案--------------------