如何消除MYsql重复记录

Posted May.18, 2009 under Programming

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