Skip to content

Instantly share code, notes, and snippets.

@Bat-Chat

Bat-Chat/addUniqueIndexMysql

Created February 6, 2016 15:58
Show Gist options
  • Save Bat-Chat/cb19f8618803f08c551f to your computer and use it in GitHub Desktop.
Save Bat-Chat/cb19f8618803f08c551f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
addUniqueIndexMysql
ALTER IGNORE TABLE table_name ADD UNIQUE INDEX unique_index_name(col_1, col_2)
DROP INDEX unique_index_name ON table_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment