how unique field in table in phpmyadmin

11 ) ALTER TABLE  `foo` ADD UNIQUE ( `bar` )
2
3or 
4
52 ) You do not have duplicates -> will apply the key without issues
6You do have duplicates -> will give an error message, nothing happened to your data
7All is unique, except several rows with NULL in them, unique constraint is still applied, as NULL is not checked when checking for unique values (you can have the entire table have a NULL value in a unique field without any error message).