DELETE t1 FROM your_table t1
INNER JOIN your_table t2
WHERE t1.id < t2.id
AND t1.duplicate_column = t2.duplicate_column;
DELETE t1 FROM your_table t1
INNER JOIN your_table t2
WHERE t1.id < t2.id
AND t1.duplicate_column = t2.duplicate_column;
本文标题：Mysql删除重复数据只保留一条
本文链接：https://www.haomeiwen.com/subject/lubaxjtx.html
网友评论