mysql删除完全重复数据保留一条 CREATETABLEtmpAS(SELECTDISTINCT*FROMoa_organization);--将不重复的数据存入新建临时表tmpDELETEFROMoa_organization;--删除对应的表INSERTINTOoa_organizationSELECT*FROMtmp;--把临时表里的数据存入对应的表DROPTABLEtmp;--删除临时表...