MySQL删除重复数据
摘要:
1 delete from TableName where id in( 2 3 select id from( 4 5 select id from TableName where name in (select name from TableName group by name having count(name) > 1) 6 and id not in(select ... 阅读全文
posted @ 2011-02-19 13:44 东云180 阅读(113) 评论(0) 推荐(0) 编辑