导入数据常出现 重复的数据 下面介绍几条sql语句来解决问题!!
cardid 是商品编号 查询编号重复的记录 并显示重复的次数
select cardid,Count(cardid) as '次数' from OfCards where 1=1 GROUP by cardid having count(cardid) >1
删除重复的记录中的id索引小的
delete from OfCards
where id not in
(select max(id) from OfCards group by cardid)