SQL UPDATE order of evaluation

MySQL does “left to right” evaluation and does “see” the new values. (Tested on 5.0.45-community-nt-log MySQL Community Edition) Furthermore, from the MySQL manual: “Single-table UPDATE assignments are generally evaluated from left to right. For multiple-table updates, there is no guarantee that assignments are carried out in any particular order.” Now, “generally” is quite vague and … Read more