MYSQL去重

DELETE tb_movie_detail_ol
FROM
 tb_movie_detail_ol,
 (
  SELECT
   min(id) id,
   movie_id
  FROM
   tb_movie_detail_ol
  GROUP BY
   movie_id
  HAVING
   count(*) > 1
 ) t2
WHERE
 tb_movie_detail_ol.movie_id = t2.movie_id
AND tb_movie_detail_ol.id > t2.id

转载于:https://www.cnblogs.com/me168/p/9564953.html