Hi, Thanks to you and everyone.
I will test the same request with the ORDER BY clause. Regards, David. -----Message d'origine----- De : Mattia Merzi [mailto:mattia.me...@gmail.com] Envoyé : mercredi 28 avril 2010 17:54 À : mysql@lists.mysql.com Objet : Re: Replication : request DELETE is not executed on slave AFAIR you can use LIMIT with replication only if you use row-based replication (or mixed), that means that you must use mysql 5.1. Greetings, Mattia. 2010/4/28 Tom Worster <f...@thefsb.org>: > 16.3.1.9. Replication and LIMIT > Replication of LIMIT clauses in DELETE, UPDATE, and INSERT ... SELECT > statements is not guaranteed, 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=dflore...@legos.fr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
