MYSQL删除重复数据

保留id最小的数据

DELETE t1 FROM table_name t1
INNER JOIN table_name t2 
WHERE t1.id > t2.id AND t1.duplicate_column = t2.duplicate_column;

保留id最大的数据

DELETE t1 FROM table_name t1
INNER JOIN table_name t2 
WHERE t1.id < t2.id AND t1.duplicate_column = t2.duplicate_column;