MySQL 数据根据单列或者多列去重保留数据重置ID

1、查看去重后的数据 DISTINCT SELECT DISTINCT movie_id,title FROM b_movie 2、 根据某一列查看重复的数据: SELECT * FROM b_movie WHERE movie_id IN ( SELECT movie_id FROM ( SELECT movie_id FROM b_movie GROUP BY movie_id HAVING count( movie_id )> 1 ) AS tmp1 ) AND mid NOT IN ( SELECT mid FROM ( SELECT min( mid ) mid FRO