MySQL Forums
Forum List  »  Stored Procedures

Simple update doesn't work in Stored Proc
Posted by: Ralph Krausse
Date: January 19, 2006 08:57PM

Here is what I have. If I enter this line in Query Browser, name gets set to '1 on the row where companyID = 13.

UPDATE Companies SET Name = '1' WHERE CompanyID = 13


All good. Now if I enter this in as a stored proc (yes, hard coded like that) and then call it from Query Browser, ALL 13 rows in my table, the name changes to '1'.

What am I doing wrong?

TIA
Ralph

Options: ReplyQuote


Subject
Views
Written By
Posted
Simple update doesn't work in Stored Proc
2092
January 19, 2006 08:57PM


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.