DELETE,
UPDATE, and
INSERT ...
SELECT statements containing a
LIMIT clause are not guaranteed to produce
the same result on the slave as on the master, since the order
of the rows affected is not defined. Such statements can be
replicated correctly only if they also contain an ORDER
BY clause.

User Comments
Add your own comment.