Unique MYSQL Columns With PHPMYADMIN


Unique MYSQL Columns With PHPMYADMIN

Alter a table to create unique columns. This will ensure there is no duplicate values in a column that is unique.

1) Open PHPMYADMIN
2) Select database >database table >Structure >(Select from option a or b below)
a) Look for Arrow next to More or U icon >Add Unique Index
b) Look for index >Click Edit next to desired field >Next to index type select Unique