验证

  • 【已验证】mysql删除多余的重复记录

    delete test as a from test as a,(select * from test group by name,value having count(1)>1) as b where a.name=b.name and a.value=b.value and a.id > b.id 一句sql就可以搞定哦...2013-06-19 16:29