Re: Writing stored procedures and functions in MySQL

[T V]

I am using
mysql database version is : 5.0.45.community-nt;

problem :
create table mytest (id int, sname varchar(15));

create procedure sp_mytest (id int, sname varchar(15))
Begin
Update tiltest set sname=sname where id=id;
End;

If i execute it :
call sp_tiltest(1,'mynametest');

It is updating all rows, what is the problem. Can the community please help me.