MySql最简单的分页存储过程

 delimiter //create procedure listpage (IN num1 int,IN num2 int)begin set @sql = concat('select * from stuinfo limit ',num1,',',num2); //连接的sql语句 prepare sq from @sql; execute sq; deallocate prepare sq;end //