ALTER TABLE synonym_unique ADD UNIQUE (word) INSERT IGNORE INTO synonym_unique (word, synonyms, uid) SELECT word, synonyms, uid from `synonym_non_unique`