(This is because the order in which the rows are updated determines which rows are ignored.) Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using mode.(Bug #11758262, Bug #50439) See Section 184.108.40.206, “Determination of Safe and Unsafe Statements in Binary Logging”, for more information.
My current php My Admin version is 4.1.7 and the current My SQL version is 5.1.73.
So, here it is again.]A very server resources friendly method to update multiple rows in the same table is by using WHEN THEN (with a very important note).
UPDATE tbl_name SET fld2 = CASE fld1WHEN val1 THEN data1WHEN val2 THEN data2ELSE fld2 ENDThe note is: do not forget ELSE.
This option takes a list of one or more partitions or subpartitions (or both).
Only the partitions (or subpartitions) listed are checked for matches, and a row that is not in any of these partitions or subpartitions is not updated, whether it satisfies the clause, are flagged as unsafe for statement-based replication.