shakirullahi/delete duplicate.sql

Created July 28, 2016 04:23

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/shakirullahi/3592b34900a5e49b4ce76fe181891eb7.js"></script>
Save shakirullahi/3592b34900a5e49b4ce76fe181891eb7 to your computer and use it in GitHub Desktop.

Download ZIP

delete duplicate rows except one with small id

Raw

delete duplicate.sql

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