删除数据库重复记录1、具体实现如下：TableCreateTableusers_groupsCREATETABLEusers_groupsidi
t10u
sig
edNOTNULLAUTO_INCREMENTuidi
t11NOTNULLgidi
t11NOTNULLPRIMARYKEYidENGINEI
oDBAUTO_INCREMENT15DEFAULTCHARSETutf8mysqlselectfromusers_groupsiduidgid111502210750231005034110501511250161045027100502810050191025011010450211100502121005011310250114110501mysqlcreatetemporarytabletmp_wrapselectfromusers_groupsgroupbyuidhavi
gcou
t1u
io
allselectfromusers_groupsgroupbyuidhavi
gcou
t1mysqltru
catetableusers_groupsmysqli
serti
tousers_groupsselectfromtmp_wrapmysqlselectfromusers_groupsiduidgid111502210750231005034110501511250161045029102501mysqldroptabletmp_wrap2、还有一个很精简的办法。查找重复的，并且除掉最小的那个。
1
fdeleteusers_groupsasafromusers_groupsasaselectmi
idfromusers_groupsgroupbyuidhavi
gcou
t1asbwhereauidbuida
daidbididuidgid111502210750231005034110501511250161045029102501
2
fr