davesgonechina/MySQL dedup

Last active January 27, 2017 02:16

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

Select an option

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

Download ZIP

MySQL dedup

Raw

MySQL dedup

	CREATE TABLE new_table as
	SELECT * FROM old_table WHERE 1 GROUP BY [column to remove duplicates by];

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