Unique constraint that allows empty values in MySQL

by

Yes, you can do this. See the MySQL reference (version 5.5).

A UNIQUE index creates a constraint such that all values in the index must be distinct. An error occurs if you try to add a new row with a key value that matches an existing row. For all engines, a UNIQUE index allows multiple NULL values for columns that can contain NULL.

More Related Contents:

  1. List of Constraints from MySQL Database
  2. Cakephp Career Database Design
  3. How to store multiple options in a single table?
  4. How to pivot a MySQL entity-attribute-value schema
  5. Implementing Comments and Likes in database
  6. MySQL: multiple tables or one table with many columns? [closed]
  7. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  8. MySQL – Conditional Foreign Key Constraints
  9. Auto Generate Database Diagram MySQL [closed]
  10. How do I add a custom CHECK constraint on a MySQL table?
  11. Storing SHA1 hash values in MySQL
  12. MySQL ENUM type vs join tables
  13. How to truncate a foreign key constrained table?
  14. Relational database design multiple user types
  15. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  16. A constraint to prevent the insert of an empty string in MySQL
  17. MySQL Removing Some Foreign keys
  18. Facebook like notifications tracking (DB Design)
  19. How to design a multi tenant mysql database
  20. DOs and DONTs for Indexes [closed]
  21. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  22. Difference between two table structure
  23. Proper database model for a user feedback system (an interesting case)
  24. Use Composite Primary Key as Foreign Key
  25. When to use a left outer join?
  26. MySQL distinction between e and é (e acute) – UNIQUE index
  27. MySQL and Check Constraints
  28. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  29. MySQL Relationships
  30. Inventory management with stock options

Leave a Comment