mysql的唯一索引列允许多个null值存在

/ mysql / 没有评论 / 86浏览

原来早有人对此讨论,然而官方认为this is not a bug.

Additional info:

From the MySQL manual:

In MySQL, a UNIQUE index is one in which all values in the index must be distinct. An error occurs if you try to add a new row with a key that matches an existing row. The exception to this is that if a column in the index is allowed to contain NULL values, it can contain multiple NULL values. This exception does not apply to BDB tables, for which an indexed column allows only a single NULL.

unique index allows duplicates if at least one of the columns is null.