cruel
Programmer
- Aug 6, 2001
- 131
I recently installed mysql on my win xp. I was testing some simple stored procedure like:
/* temp exec delimiter for end SP or function code */
delimiter //
create procedure simple (in parm1 varchar(20))
BEGIN
select count(*) into from db1.parm2;
END
//
demiliter ;
and I got the above error message, something like check the syntax near 'procedure .....'. I believe I have the latest version. What could be the issue here? Thanks
/* temp exec delimiter for end SP or function code */
delimiter //
create procedure simple (in parm1 varchar(20))
BEGIN
select count(*) into from db1.parm2;
END
//
demiliter ;
and I got the above error message, something like check the syntax near 'procedure .....'. I believe I have the latest version. What could be the issue here? Thanks