msyql表去重命令

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)

欢迎关注公众号：