Updating mysql table Free sexy site
I needed to populate the product_id field in the activities table, where activities are numbered in a unit, and units are numbered in a level (identified using a string ??
N), such that one can identify activities using an SKU ie L1U1A1.
In this case, the use of a multi-table update is even better.
will be slow, but this is the only data I have to match them together. I could create a third table for the merged results, if that would be faster? However, I prefer 'JOIN' syntax for joins rather than multiple 'WHERE' conditions.
Using rollbacks, you can ensure that they are treated as one unit of work, ie either they are all executed or none of them are, to keep data consistent.