Unique constraint that allows empty values in MySQL

Viewed 52793

I have a field that stores product codes. The codes are unique, but some products simply doesn't have a code. I can't invent codes because those are providers codes.

Is this kind of constraint possible in MySQL?

I'm a noob with stored procedures and triggers, so if the solution involves one of these, please be patient.

Update: The column is NOT Null. That's why I was unable to do this.

3 Answers
Related