how to find duplicates in mysql# Database - 数据库
b*r
1 楼
In this talbe, each line is in this format:
ID, Name
1, abc
2,de
3,abc -------duplicate
4,de -------duplicate
5,gg
.
.
.
ID is the primary key. How to find and delete any possilbe duplicates of
"Name"? Thanks in advance.
ID, Name
1, abc
2,de
3,abc -------duplicate
4,de -------duplicate
5,gg
.
.
.
ID is the primary key. How to find and delete any possilbe duplicates of
"Name"? Thanks in advance.