Can Mysql hold possible field values?

Hi, I am attempting to create a database and have a query. Is it possible for mysql to contain the possible field values in the database rather than creating the options in the application? For example Field_A can only be Yes or No, Field_B can be 50% or 80% etc. I feel that creating the

Re: Can Mysql hold possible field values?

Shaun, Check out the enum and set column types in the manual. Enum works well for things like 'Yes', 'No'. For a percentage field, that has to be checked in the application. -Eric On Mon, 17 Jan 2005 14:12:53 +, shaun thornburgh [EMAIL PROTECTED] wrote: Hi, I am attempting to create

Re: Can Mysql hold possible field values?

At 2005-01-17 15:12, shaun thornburgh wrote: I am attempting to create a database and have a query. Is it possible for mysql to contain the possible field values in the database rather than creating the options in the application? For example Field_A can only be Yes or No, Field_B can be 50% or

Re: Can Mysql hold possible field values?

hold possible field values? Date: Mon, 17 Jan 2005 15:23:42 +0100 At 2005-01-17 15:12, shaun thornburgh wrote: I am attempting to create a database and have a query. Is it possible for mysql to contain the possible field values in the database rather than creating the options in the application

Re: Can Mysql hold possible field values?

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

Re: Can Mysql hold possible field values?

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.