我写了一个存储过程,可传过来的参数总是不生效。
请帮我看看:
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')
请帮我看看:
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')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货