List:General Discussion« Previous MessageNext Message »
From:Jigal van Hemert Date:January 17 2005 3:22pm
Subject:Re: Can Mysql hold possible field values?
View as plain text  
> 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?

ENUM is a type that has many alternative values for one single property:
e.g. eye colour is one of these alternatives: brown, green, blue, grey.

SET is a type that hold many different properties which can either be
switched on or off;
e.g. sports available are: soccer, tennis, basketball, track. Member has
selected: soccer and track, so the field contains: 'soccer,track'.

Regards, Jigal.

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