SELECT id,concat( spare_id,user_id,stock_id) uuid FROM t_spare_user_rel WHERE stock_id isnotnull;
2、以新字段为条件查出重复数据
SELECTCOUNT(a.id),a.uuid FROM(SELECT id,concat( spare_id,user_id,stock_id) uuid FROM t_spare_user_rel WHERE stock_id isnotnull) a GROUPBY a.uuid HAVINGCOUNT(a.id)>1
3、查出最小的一条数据
SELECTmin(a.id)FROM(SELECT id,concat( spare_id,user_id,stock_id) uuid FROM t_spare_user_rel WHERE stock_id isnotnull) a GROUPBY a.uuid HAVINGCOUNT(a.id)>1
4、删除最小的重复数据
DELETEFROM t_spare_user_rel WHERE id IN(SELECTmin(a.id)FROM(SELECT id,concat( spare_id,user_id,stock_id) uuid FROM t_spare_user_rel WHERE stock_id isnotnull) a GROUPBY a.uuid HAVINGCOUNT(a.id)>1)