Skip to content

Instantly share code, notes, and snippets.

@uovidiu

uovidiu/mysql - find and remove duplicates

Created August 19, 2013 14:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save uovidiu/6269799 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save uovidiu/6269799 to your computer and use it in GitHub Desktop.
Download ZIP
mysql search duplicates mysql remove duplicates
Raw
mysql - find and remove duplicates
// search duplicates
SELECT field, field_1, count(*)
FROM table
GROUP BY field, field_1 HAVING count(*) > 1;
//remove duplicates
ALTER IGNORE TABLE `sometable` ADD UNIQUE INDEX(field,field_1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment