it's worth a try -- the manual for 4.1 has the same text about ORDER BY in section 14.7.
On 4/28/10 12:30 PM, "David Florella" <dflore...@legos.fr> wrote: > 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=arch...@jab.org
