MYSQL中怎么删除重复的号码？

是不是这样的语句 delete from a where count(phoneNo)>1;

---

你的意思是删除有重复号码的所有记录呢？还是过滤重复的记录只剩其中一条记录？

---

就是删除重复号码 只剩下一条不重复记录的

---

假如你的表有ID唯一值列的话，则：

SQL code:
select * from tb_name a where not exists (select 1 from tb_name b where b.phoneNo=a.phoneNo and b.ID>a.ID)



如果没有类似ID这里唯一值列的话，那考虑中间转换成有这样唯一值的列才处理。

如果只是要phoneNo这一列的话，那直接：

SQL code:
select phoneNo from a group by phoneNo;

---

SQL code:
mysql> select * from tb;
+------+------+
| rid | con |
+------+------+
| 1 | b |
| 2 | b |
| 3 | b |
| 1 | a |
+------+------+
4 rows in set (0.00 sec)

mysql> delete from tb where rid in (select rid from (select rid,count(rid) c fr
om tb group by rid having c>1) t);
Query OK, 2 rows affected (0.03 sec)

mysql> select * from tb;
+------+------+
| rid | con |
+------+------+
| 2 | b |
| 3 | b |
+------+------+
2 rows in set (0.00 sec)

---

mysql> delete from gzt