21,887
社区成员
发帖
与我相关
我的任务
分享
delimiter $
drop procedure if exists uchome_blog_subsql_limitnum;
create procedure uchome_blog_subsql_limitnum(in lmum int,in subsql varchar(200))
begin
declare s int;
set s=lmum;
if subsql<>"" then
select * from uchome_blog where 1=1 and subsql limit 0,3;
else
select * from uchome_blog order by blogid desc limit 0,100;
end if;
end$
delimiter ;
call uchome_blog_subsql_limitnum(10,' blogid=1')