[New post] How unique field in table in PHPmyadmin?

Subash Chandran posted: "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" New post on Poopcode How unique field in table in PHPmyadmin? by Subash Chandran 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). Read more of this post Subash Chandran | November 20, 2021 at 11:36 am | Tags: how to make a column unique in phpmyadmin, how to make a unique table in phpmy admin, How to make column unique in phpmyadmin, how to set field as unique in phpmyadmin, how unique field in table in phpmyadmin, i need unique data in phpmyadmin, make a field unique mysql phpmyadmin, make column unique phpmyadmin, phpmyadmin manually field making unique, phpmyadmin unique column, unique column phpmyadmin, unique in phpmyadmin, unique mysql phpmyadmin | Categories: Snippets | URL: https://wp.me/pb9kQA-4u5 Comment    See all comments Unsubscribe to no longer receive posts from Poopcode. Change your email settings at Manage Subscriptions. Trouble clicking? Copy and paste this URL into your browser: https://poopcode.com/how-unique-field-in-table-in-phpmyadmin/