Skip to content

Instantly share code, notes, and snippets.

@digiari

digiari/remove_duplicated.sql

Created February 11, 2016 16:32
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save digiari/90ba60c3e6b3795e7ea3 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save digiari/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