Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ER_PARSE_ERROR 1064 42000

Status
Not open for further replies.

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
 
Thanks. But that was just a typo during posting. It could be without "into" or with an "into" having an out parameter set up. I am wondering if anyone else experiences similar messages when create stored procedure or function?

* temp exec delimiter for end SP or function code */
delimiter //

create procedure simple (in parm1 varchar(20))
BEGIN

select count(*) from db1.parm2;

END
//

demiliter ;
 
The latest production version of MySQL (4.1) doesn't support stored procedures, but I think version 5 (unstable) does.

Which version do you have?
 
I am not at mysql pc, but I am pretty sure it is 4.1. If that is the case, I will simply wait for version 5 to be in production. Sorry, I am a freeloader at mysql. I wish I could contribute. and Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top