--page为页码数,rowss为页数
DELIMITER $$
CREATE PROCEDURE proc(page INT,rowss INT)BEGIN
DECLARE pageindex INT;
SET pageindex:=(page-1)*rowss;
SET @er=CONCAT('select * from person LIMIT ',pageindex,',',rowss,' ');
PREPARE r FROM @er;
EXECUTE r;
END$$
DELIMITER;
--执行
CALL proc(1,5);
--效果