How to update multiple rows at once please
Greetings,
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?
Thanks