drop procedure get_page ; delimiter // create procedure get_page(ppage int,psize int) beginset @ppage=ppage; set @psize=psize; set @pbegin=(@ppage-1)*psize ; set @str='select * from money order by paytime limit ?,?'; prepare smt from @str; execute smt using @pbegin,@psize; end // delimiter ;
drop procedure get_page ; delimiter // create procedure get_page(ppage int,psize int) beginset @ppage=ppage; set @psize=psize; set @pbegin=(@ppage-1)*psize ; set @str='select * from money where a like %aa% order by paytime limit ?,?'; prepare smt from @str; execute smt using @pbegin,@psize; end // delimiter ;比如说我想加一个where的条件,where a like %aa%,这样就查询不了,这是什么原因啊
select * from T limit tmp ///这里用这样不行!!变量只能用于where后面!!而且mysql中也不能想sql server那样是用exec(sql);;所以现在一直都没找到方法!
delimiter //
create procedure get_page(ppage int,psize int)
beginset @ppage=ppage;
set @psize=psize;
set @pbegin=(@ppage-1)*psize ;
set @str='select * from money order by paytime limit ?,?';
prepare smt from @str;
execute smt using @pbegin,@psize;
end
//
delimiter ;
delimiter //
create procedure get_page(ppage int,psize int)
beginset @ppage=ppage;
set @psize=psize;
set @pbegin=(@ppage-1)*psize ;
set @str='select * from money where a like %aa% order by paytime limit ?,?';
prepare smt from @str;
execute smt using @pbegin,@psize;
end
//
delimiter ;比如说我想加一个where的条件,where a like %aa%,这样就查询不了,这是什么原因啊