delete from lb_paint_category where id not in (SELECT a.id FROM (SELECT min( id ) id FROM lb_paint_category WHERE paint_id LIKE "02%" GROUP BY category_id, paint_id) as a)
欢迎关注公众号:
delete from lb_paint_category where id not in (SELECT a.id FROM (SELECT min( id ) id FROM lb_paint_category WHERE paint_id LIKE "02%" GROUP BY category_id, paint_id) as a)
欢迎关注公众号: