From http://stackoverflow.com/questions/4685173/delete-all-duplicate-rows-except-for-one-in-mysql sql删除重复值 - Cacher Snippet

5/20/2016 - 12:59 PM

From http://stackoverflow.com/questions/4685173/delete-all-duplicate-rows-except-for-one-in-mysql sql删除重复值

From http://stackoverflow.com/questions/4685173/delete-all-duplicate-rows-except-for-one-in-mysql sql删除重复值

new_gist_file.sql

# 1) If you want to keep the row with the lowest id value:

DELETE n1 FROM names n1, names n2 WHERE n1.id > n2.id AND n1.name = n2.name
# 2) If you want to keep the row with the highest id value:

DELETE n1 FROM names n1, names n2 WHERE n1.id < n2.id AND n1.name = n2.name