mysql 删除重复项 

DELETE
FROM
    j_rank_rise_record
WHERE
    id NOT IN (

SELECT id FROM (

SELECT * FROM j_rank_rise_record group by userid,rank_lv

) t

)

 

posted @ 2018-07-09 11:32  不知为何就叫呵呵  阅读(104)  评论(0)  编辑  收藏  举报