| | | |

2017年3月9日

摘要： delete from 表 where id in (select id from (select max(id) as id,count(列) as count from 表group by 列 having count >1 order by count desc) as tab ) 阅读全文

posted @ 2017-03-09 15:08 小石头st 阅读(250) 评论(0) 推荐(0)

mysql 数据表中查找重复记录（条数）

摘要： SELECT 字段,COUNT(*) AS COUNT FROM 表名 GROUP BY 字段 HAVING COUNT>1; 阅读全文

posted @ 2017-03-09 10:31 小石头st 阅读(782) 评论(0) 推荐(0)