Ofline
95928 days on xHamster
35165M profile views
69729K subscribers
26413 comments left

Updating phpmyadmin

(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 16.2.1.3, “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.

Please or register to post comments
If spammers comment on your content, only you can see and manage such comments Delete all

Updating phpmyadmin introduction

Updating phpmyadmin

Recent posts

07-Nov-2018 23:19
08-Nov-2018 07:17
08-Nov-2018 19:56
09-Nov-2018 03:48