MySQL Forums
Forum List  »  MySQL Query Browser

How to update multiple rows at once please
Posted by: Frank Gatlin
Date: June 07, 2012 02:46PM


I am fairly new to MySQL (and any other database for that matter). I am needing to update a row in my table with multiple data changes.

Currently, the row looks similar to:

{SEF, plt[1/10], 250, 9.75, unit0};{SEF, plt[1/1], 250, 97.5, unit0};{UPS, box[1/1], , 9.75, unit0};

In the last bracket UPS, I need to update the weight portions of several items. Currently, the weight for this item is set to 9.75, and i will need to set it to 10.75.

The problem lies in this: Each item has a different weight associated with it, and I need to add 1 pound to each item to cover the weight of shipping materials. ergo, some rows will not be exactly like the one above, and some will not have SEF in them at all.

Any ideas?


Options: ReplyQuote

Written By
How to update multiple rows at once please
June 07, 2012 02:46PM

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.