开发者

Problem with stored procedure in MySQL

开发者 https://www.devze.com 2023-01-30 10:55 出处:网络
I\'ve made the following procedure: /*Stored procedure*/ create proce开发者_JAVA百科dure SP_getlagerstatus(in Kategori VARCHAR(15), in minverdi int(3))

I've made the following procedure:

/*Stored procedure*/
 create proce开发者_JAVA百科dure SP_getlagerstatus(in Kategori VARCHAR(15), in minverdi int(3))
 select * from deler join delekategori on deler.DelekategoriID=delekategori.DeleKategoriID
 where DeleKategoriNavn ='Kategori' and Lagerstatus > 'minverdi';

when i run it with call SP_getlagerstatus('biler',1);I dont get any results, but when I run query directly as:

select * from deler join delekategori on deler.DelekategoriID=delekategori.DeleKategoriID
 where DeleKategoriNavn ='biler' and Lagerstatus > 1;

I get the desired result. What am I missing?

/Andy.l


omit the ' around the parameters

 select * from deler join delekategori on deler.DelekategoriID=delekategori.DeleKategoriID
 where DeleKategoriNavn =Kategori and Lagerstatus > minverdi;
0

精彩评论

暂无评论...
验证码 换一张
取 消