Posted by Captain Paralytic on 09/14/07 15:11

On 14 Sep, 11:55, Pugi! <pugin...@gmail.com> wrote:
> I have a table with a unique constraint on two integer columns.
> Works fine, but one of the two columns can be null and then the
> constraint does not work.
> 1 2 : OK
> 1 3 : OK
> 1 2 : error
> 2 null : OK
> 2 null : OK -> I want this to result in an error
>
> Pugi!

Do not multi-post. Cross-post if you must but don't multi post It
wastes
people's time. http://www.blakjak.demon.co.uk/mul_crss.htm

• Next in forum: php5 mysql5.0 win problems
• Prev in forum: Re: How to enforce an ENUM ?
• Thread view: Re: Unique constraint for the columns does not work when one of values is null.

[Reply to this message]