Re: Can Mysql hold possible field values?

[shaun thornburgh]

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?

Thanks for your help
From: Mattias J <[EMAIL PROTECTED]>
To: "shaun thornburgh" <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject: Re: Can Mysql 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?

For example Field_A can only be Yes or No, Field_B can be 50% or 80% etc.
http://dev.mysql.com/doc/mysql/en/ENUM.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]