MySQL查询重复记录sql语句
摘要:常用的语句1、查找表中多余的重复记录,重复记录是根据单个字段(mail_id)来判断代码如下 复制代码 SELECT * FROM table WHERE mail_id IN (SELECT mail_id FROM table GROUP BY mail_id HAVING COUNT(mail_id) > 1);2、删除表中多余的重复记录,重复记录是根据单个字段(mail_id)来判断,只留有rowid最小的记录代码如下 复制代码 DELETE FROM table WHERE mail_id IN (SELECT mail_id FROM table GROUP BY mail_
阅读全文
posted @
2013-07-01 18:01
烤德
阅读(1864)
推荐(0)