mysql - 如何从MySQL表中删除重复值

Question

我正在查找查询，删除所有重复值。

Example Table:

1 ABC
2 BBB
3 DAC
4 ABC
5 AAA
6 ABC

output required

1 ABC
2 BBB
3 DAC
5 AAA

感谢您的帮助，我谷歌它无法找到确切的解决方案。

Answer 1

如果您想对重复值执行实际的 DELETE 操作(同时保留具有最低 id 的值)，您可以使用多个表 DELETE 语法:

DELETE a FROM tbl a
LEFT JOIN
(
    SELECT MIN(id) AS id, name
    FROM tbl
    GROUP BY name
) b ON a.id = b.id AND a.name = b.name
WHERE b.id IS NULL

---

查看demonstration DELETE 操作