1.代码如下:
DELIMITER $$
CREATE
PROCEDURE `one`.`sdf1`(try INT,ret INT)
BEGIN
DECLARE index1 INT;
SET index1=(try-1)*ret;
SET @ins=CONCAT('select * from liu limit ',index1,',',ret,'');
PREPARE ju FROM @ins ;
EXECUTE ju ;
END$$
DELIMITER ;
2.调用存储过程:
CALL sdf1(1,5);
运行后如下图:
好了,一个简单的分页存储过程就实现了