Skip to content

Instantly share code, notes, and snippets.

@diegoarigony

diegoarigony/remove_duplicated.sql

Created February 11, 2016 16:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save diegoarigony/90ba60c3e6b3795e7ea3 to your computer and use it in GitHub Desktop.
Save diegoarigony/90ba60c3e6b3795e7ea3 to your computer and use it in GitHub Desktop.
Download ZIP
Remove duplicated entries from mysql db - From http://stackoverflow.com/a/3312066/3641927
Raw
remove_duplicated.sql
ALTER IGNORE TABLE jobs
ADD UNIQUE INDEX idx_name (site_id, title, company);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment