mysql去重复保留一条

mysql去重复保存一条怎么操作呢？一起来看下吧：
1查找表中多余重复记录，重复记录是依据单独字段（peopleId）来判定
SELECT*FROMpeopleWHEREpeopleId IN(SELECTpeopleIdFROMpeopleGROUP BYpeopleIdHAVINGcount(peopleId)>1)2删掉表中多余重复记录，重复记录是依据单独字段（peopleId）来判定，只留有rowid最小纪录
DELETEFROMpeopleWHEREpeopleName IN(SELECTpeopleNameFROMpeopleGROUP BYpeopleNameHAVINGcount(peopleName)>1)AND peopleId NOT IN(SELECTmin(peopleId)FROMpeopleGROUP BYpeopleNameHAVINGcount(peopleName)>1)3查找表中多余重复记录（多个字段）
SELECT*FROMvitae aWHERE(a.peopleId,a.seq)IN(SELECTpeopleId,seqFROMvitaeGROUP BYpeopleId,seqHAVINGcount(*)>1)4删掉表中多余重复记录（多个字段），只留有rowid最小纪录
DELETEFROMvitae aWHERE(a.peopleId,a.seq)IN(SELECTpeopleId,seqFROMvitaeGROUP BYpeopleId,seqHAVINGcount(*)>1)AND rowid NOT IN(SELECTmin(rowid)FROMvitaeGROUP BYpeopleId,seqHAVINGcount(*)>1)5查找表中多余重复记录（多个字段），不包括rowid最小纪录
SELECT*FROMvitae aWHERE(a.peopleId,a.seq)IN(SELECTpeopleId,seqFROMvitaeGROUP BYpeopleId,seqHAVINGcount(*)>1)AND rowid NOT IN(SELECTmin(rowid)FROMvitaeGROUP BYpeopleId,seqHAVINGcount(*)>1)6清除一个字段的左侧的第一位：
UPDATE tableNameSET[Title]=RIGHT([Title],(len([Title])-1))WHERETitle LIKE'村%'7清除一个字段的右侧的第一位：
UPDATE tableNameSET[Title]=LEFT([Title],(len([Title])-1))WHERETitle LIKE'%村'8假删掉表中多余重复记录（多个字段），不包括rowid最小纪录
UPDATE vitaeSET iSPAss=-1WHEREpeopleId IN(SELECTpeopleIdFROMvitaeGROUP BYpeopleId之上就是小编今天的分享，希望可以帮助到大家。
【mysql去重复保留一条】

mysql去重复 保留一条

mysql去重复保留一条