The issue, described below is very strange when you find it, because it works only in MySql. In MySql the update keeps track of the order of the parameters updated. So while for any known DBMS when you update a field computed considering another one (i.e. set A = 10, B = A…) the value of A and B are calculated starting from the original value for each update in MySql as soon as you update a field, this new value will be used instead of the original. Besides this you can use the order clause to specify HOW update the values. This cose works on MySql and on SQL…