DELETE FROM table WHERE key LIKE '%100%' Also I tried to continously insert big numbers of new records (around 50 millions new records) and tried to delete 1 record on master, I checked the slave not synchronized. Is it just a lag?
Willy On Fri, 2009-06-26 at 16:14 +0800, Moon's Father wrote: > > Could you tell me your detail statements? > On Wed, Jun 24, 2009 at 9:46 AM, sangprabv <sangpr...@gmail.com> > wrote: > Hi, > I found every time I try to do multiple rows delete on > replicated MySQL > is always failed. Is there any explanation regarding this > issue and how > to solve it? TIA. > > > > Willy > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=yueliangdao0...@gmail.com > > > > > -- > David Yeung, > MySQL Senior Support Engineer, > Sun Gold Partner. > My Blog:http://yueliangdao0608.cublog.cn -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org