MySQL 동일명 데이터 중복 제거

한 파일만 남기고 중복 제거

delete from <table> where id not in ( select id from ( select id from <table> group by image) as id);

중복 데이터 전체 제거

delete from <table> WHERE image IN ( SELECT image FROM (SELECT image FROM <table> GROUP BY image HAVING count(*) > 1) temp_table) ;

select count(image) from <table>;

select count(distinct image) from <table>;