56,687
社区成员
发帖
与我相关
我的任务
分享
DELIMITER //
CREATE PROCEDURE PROC_NAME(变量一,变量二)
BEGIN
DECLARE ssqlVARCHAR(100);
SET ssql="SELECT*FROM TABLE_NAEM LIMIT ?,?";
SET@fvar=变量一;
SET@svar=变量二;
SET@SQUERY=ssql;
PREPARE STMTFROM@SQUERY;
EXECUTE STMT USING@fvar,@svar;
END;//
DELIMITER ;
BEGIN
DECLARE ssql VARCHAR(100);
SET ssql="SELECT * FROM TABLE_NAEM LIMIT ?,?";
SET @fvar=变量一;
SET @svar=变量二;
SET @SQUERY=ssql;
PREPARE STMT FROM @SQUERY;
EXECUTE STMT USING @fvar,@svar;
END;
//
DELIMITER ;