如何消除MYsql重复记录

May 18th, 2009 by Bruce Dou Views:86

# delete from cdb_uc_members a where a.uid = (select max(b.uid) from cdb_uc_members b where a.username=b.username);

Share and Enjoy:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay
  • 豆瓣
  • DZone
  • LinkedIn
  • MySpace
  • Reddit
  • RSS

Also see:

Tags: ,

Leave a Reply