List:General Discussion« Previous MessageNext Message »
From:Alec.Cawley Date:January 17 2005 3:08pm
Subject:Re: Can Mysql hold possible field values?
View as plain text  
"shaun thornburgh" <shaunthornburgh@stripped> wrote on 17/01/2005 
14:57:39:

> Hi Guys,
> 
> Thanks for your replies, i have also found SET which appears to do the 
same 
> thing, is there a reason why everyone suggested ENUM as opposed to SET?

SET and ENUM are different things. An ENUM can have only one value e.g 
TRUE or FALSE. A SET is a group of possible values e.g. IN_STOCK, 
ON_ORDER, SHORTAGE, OBSOLETE. A in the first case the thing must be either 
TRUE or FALSE, but there are sizteen posssible combinations such as 
IN_STOCK/OBSOLETE, ON_ORDER/SHORTAGE and so on..

        Alec
Thread
Can Mysql hold possible field values?shaun thornburgh17 Jan
  • Re: Can Mysql hold possible field values?Eric Bergen17 Jan
  • Re: Can Mysql hold possible field values?Mattias J17 Jan
    • Re: Can Mysql hold possible field values?shaun thornburgh17 Jan
      • Re: Can Mysql hold possible field values?Alec.Cawley17 Jan
      • Re: Can Mysql hold possible field values?Jigal van Hemert17 Jan