实现效果
![](https://i-blog.csdnimg.cn/blog_migrate/58e8ae98934b1aefa33ed545c1731d11.png)
DELIMITER $$
CREATE
/*pro为存储过程名字
pageindex 当前页
rs
*/
PROCEDURE `person`.`pro`(pageindex INT,rs INT)
BEGIN
SET @index=CONCAT('select *from text limit ',((pageindex-1)*rs),',',rs,'');//text为表名
PREPARE s FROM @index;
EXECUTE s;//执行sql语句
END$$
DELIMITER ;
//调用存储过程
CALL pro(1,5);