mysql存储过程实现分页

delimiter //
create procedure shgoods_procedure(in pageno int,in pagesize int)
begin
#a总数，b总页数,start开始位置
declare a,b,start1 int;
select count(*) into a from sh_goods;
if pagesize<=1 then set pagesize=3;
end if;
set b=ceil(a/pagesize);
if pageno<=1 then set pageno=1;
elseif pageno>=pagesize then set pageno=pagesize;
end if;
set start1=(pageno-1)/b;
set @sql_limitpage = concat('select * from sh_goods limit ',start1,"\,",pagesize);
prepare result from @sql_limitpage;
execute result ;
deallocate prepare result ;
end;
//
delimiter;

call shgoods_procedure(2,3);
————————————————
版权声明：本文为CSDN博主「一直被套路」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/m0_43609780/article/details/122140582