mysql 刪除重複項

不知為何就叫呵呵發表於2018-07-09
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

)

 

相關文章