Why doesn't thisw work - syntax error
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?
Subject
Views
Written By
Posted
Why doesn't thisw work - syntax error
2457
October 19, 2005 08:12PM
1717
October 20, 2005 03:23AM
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.