Sql updating multiple rows with different values
Because of this indeterminacy, referencing other tables only within sub-selects is safer, though often harder to read and slower than using a join.
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.
(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.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.
Hi I'm hoping one of you kind folk can help with this.