pcalves/delete_dupes.sql

Last active January 3, 2016 21:09

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/pcalves/8519805.js"></script>
Save pcalves/8519805 to your computer and use it in GitHub Desktop.

Download ZIP

Delete duplicate entries in a table (MySQL).

Raw

delete_dupes.sql

	DELETE FROM table
	USING table, table t2
	WHERE table.id > t2.id
	AND table.`column` = t2.`column`

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment