If you want the index to be unique, you can specify the keyword UNIQUE. For example:
mysql> ALTER TABLE employees ADD UNIQUE INDEX unique_name (last_name, first_name);# There are few duplicate entries in employees database, the above statement is shown for illustration purpose only.