/PHP/How unique field in table in phpmyadmin

How unique field in table in phpmyadmin

1 ) ALTER TABLE  `foo` ADD UNIQUE ( `bar` )

or 

2 ) You do not have duplicates -> will apply the key without issues
You do have duplicates -> will give an error message, nothing happened to your data
All 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).

Similar codes

4 votes337 views2 answers
On update current timestamp laravel migration
PHP
1 vote312 views1 answer
Get advanced custom field value in wordpress
PHP
0 vote333 views1 answer
Check the existing image in s3 laravel
PHP
1 vote363 views1 answer
Laravel $loop interation
PHP
-2 votes347 views2 answers
Lowercase in array php
PHP
5 votes371 views6 answers
Php get only numbers from string
PHP
1 vote337 views1 answer
Php recursive function to build array
PHP
0 vote309 views1 answer
Undefined property: CI::$file
PHP
1 vote318 views1 answer
Formdata jquery ajax php
PHP
0 vote333 views2 answers
Laravel General error: 1215 Cannot add foreign key constraint"
PHP Laravel