2011年2月19日

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) 编辑

导航