Deduping mySQL table
A programming error lead to multiple insertions of identical rows in this
table. I am aware that constraints in the schema could prevent the
insertions.
I am trying to find a way to delete all but the newest (highest id) row
for each round/number pair. I could definitely script this but I wondered
if there is a way to do this in pure SQL?
No comments:
Post a Comment