I use mysql replication. At slave, i read in aa.err Statement may not be safe to log in statement format. Statement: update idv_product set visit = visit+1 where id = '173' limit 1 I don`t understad, guide me about error above.
closed as not a real question by quanta, sam, Iain, MDMarra, Scott Pack Nov 11 '11 at 23:25
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.
That error message happens because the statement relies on the order that the records are stored on disk. There are a few things you can do to stop the error happening: