"shaun thornburgh" <[EMAIL PROTECTED]> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
