Mysql删除重复数据只保留一条

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