Skip to content

Instantly share code, notes, and snippets.

@NaWer

NaWer/delete_duplicate.sql

Created September 2, 2014 12:35
Show Gist options
  • Save NaWer/e28d874cf17673d700e8 to your computer and use it in GitHub Desktop.
Save NaWer/e28d874cf17673d700e8 to your computer and use it in GitHub Desktop.
Download ZIP
Delete duplicate row on a MySQL table
Raw
delete_duplicate.sql
# Source : http://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql
ALTER IGNORE TABLE my_table_name ADD UNIQUE INDEX my_index_name (my_column_1, my_column_2, my_column_3, ... );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment