DELIMITER $$
CREATE
PROCEDURE `test`.`P_paging1`(IN pagesize INT,IN myrows INT)
BEGIN
SET @name2=CONCAT('select * from person limit ',(pagesize-1)*myrows,',',myrows,' ');
PREPARE r FROM @name2;
EXECUTE r;
END$$
DELIMITER ;
#调用存储过程
CALL `test`.`P_paging1`(2,5);
CREATE
PROCEDURE `test`.`P_paging1`(IN pagesize INT,IN myrows INT)
BEGIN
SET @name2=CONCAT('select * from person limit ',(pagesize-1)*myrows,',',myrows,' ');
PREPARE r FROM @name2;
EXECUTE r;
END$$
DELIMITER ;
#调用存储过程
CALL `test`.`P_paging1`(2,5);