//删除id重复的数据，适合id是手工主键 delete person as a from person as a, ( select *,min(id) from person group by id having count(1) > 1 ) as b where a.id = b.id
//查找重复的，并且除掉最小的那个delete tb_person as a from tb_person as a, ( select *,min(id) from tb_person group by name having count(1) > 1 ) as b where a.name = b.name and a.id > b.id;
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
