But that doesn't work. What's wrong with this?
The second question is:
How can I manage to say that empty fields (like #1062 - Duplicate entry '' for key 5 ) are excepted from UNIQUE?
That's the problem, because there are empty fields in the column which are not UNIQUE, so I'd like to make an exception to exclude
those empty fields while creating a new UNIQUE column.
knallbernd wrote:That's the problem, because there are empty fields in the column which are not UNIQUE, so I'd like to make an exception to exclude
those empty fields while creating a new UNIQUE column.
It is not possible to exclude some rows from UNIQUE index. You have to delete conflicting rows.