-
Mysql删除重复数据保留最小的id 的解决方法
在网上查找删除重复数据保留id最小的数据,方法如下:DELETEFROMpeopleWHEREpeopleName IN (SELECTpeopleNameFROMpeopleGROUP BYpeopleNameHAVINGcount(
在网上查找删除重复数据保留id最小的数据,方法如下:DELETEFROMpeopleWHEREpeopleName IN (SELECTpeopleNameFROMpeopleGROUP BYpeopleNameHAVINGcount(