MySQL Forums
Forum List  »  Stored Procedures

Why doesn't thisw work - syntax error
Posted by: Martina Long
Date: October 19, 2005 08:12PM

I'm used to writing stored procedures in MS SQL and this is what I would write to return all of the fields in a table clientdetails where the clientnumber being sent in is in the database.

CREATE PROCEDURE `leswana`.`accounts` (IN @clientnumber INT)
BEGIN

select * from clientdetails where clientnumber=@clientnumber

END

What is wrong with this for MySQL, how do I write it?

Options: ReplyQuote


Subject
Views
Written By
Posted
Why doesn't thisw work - syntax error
2457
October 19, 2005 08:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.