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?
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 <sangprabv@stripped>
> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> David Yeung,
> MySQL Senior Support Engineer,
> Sun Gold Partner.
> My Blog:http://yueliangdao0608.cublog.cn