bfintal/query.sql

Created February 25, 2020 05:19

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

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

Download ZIP

Remove duplicate entries in MySQL table when you have no unique IDs. Change `mytable` to the name of your table.

Raw

	CREATE TABLE `temp` like `mytable`;
	INSERT `temp` SELECT DISTINCT * FROM `mytable`;
	DROP TABLE `mytable`;
	ALTER TABLE `temp` RENAME `mytable`;

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