删除数据库中多余的重复记录(在mysql的数据库上测试过,成功删除)
delete a from student a,(select xm,xh,max(UUID) UUID,count(*) mid from student group by xm,xh having count(*)>1) b where a.xm=b.xm and a.UUID!=b.UUID
posted on 2013-10-17 11:44 passer1991 阅读(133) 评论(0) 编辑 收藏 举报
delete a from student a,(select xm,xh,max(UUID) UUID,count(*) mid from student group by xm,xh having count(*)>1) b where a.xm=b.xm and a.UUID!=b.UUID
posted on 2013-10-17 11:44 passer1991 阅读(133) 评论(0) 编辑 收藏 举报