Skip to content

Instantly share code, notes, and snippets.

@escuccim

escuccim/gist:e8c49993616468e6305e062e4d5765b2

Created April 12, 2017 07:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save escuccim/e8c49993616468e6305e062e4d5765b2 to your computer and use it in GitHub Desktop.
Save escuccim/e8c49993616468e6305e062e4d5765b2 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Query to delete duplicate rows
Raw
gistfile1.txt
DELETE n1 FROM names n1, names n2 WHERE n1.id > n2.id AND n1.name = n2.name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment