MySQL Forums
Forum List  »  Newbie

Re: UPDATE
Posted by: Paul McArdle
Date: July 03, 2005 02:27AM

if you want every row updated remove the were clause.
UPDATE `mytable` SET value1 = select value1 + 1 from `mytable` where whatever = wharever

Options: ReplyQuote


Subject
Written By
Posted
July 03, 2005 02:20AM
Re: UPDATE
July 03, 2005 02:27AM


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.