List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 28 2001 9:51pm
Subject:Re: Unique field question.
View as plain text  
At 3:22 PM -0500 9/28/01, Jay Paulson wrote:
>Hello-
>
>Quick question here... I've looked in the mysql docs but they are so freak'n
>huge that I thought I was just ask you all and maybe you could point me to
>the right place.  When you make a field unique (besides the key) does that
>mean that it can't be the same as another row for the same field?

If it's a PRIMARY KEY.  If it's a UNIQUE index, yes, except that NULL
values can occur multiple times if the column is allowed to contain NULL.

>
>Thanks,
>Jay


-- 
Paul DuBois, paul@stripped
Thread
Questions about table_optionsCorin Hartland-Swann28 Sep
  • Questions about table_optionsMichael Widenius28 Sep
    • Re: Questions about table_optionsCorin Hartland-Swann28 Sep
      • Re: Questions about table_optionsMichael Widenius29 Sep
    • Re: Questions about table_optionsCorin Hartland-Swann28 Sep
      • Unique field question.Jay Paulson28 Sep
        • Re: Unique field question.Paul DuBois28 Sep
      • Re: Questions about table_optionsCorin Hartland-Swann29 Sep
        • Re: Questions about table_optionsMichael Widenius29 Sep