日期:2014-05-18 浏览次数:20464 次
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
------解决方案--------------------