- Original Message -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 29, 2004 7:37 AM
Subject: Re: Fw: column choices for certain data
> In article <[EMAIL PROTECTED]>,
> "Rhino" <[EMAIL PROTECTED]&g
In article <[EMAIL PROTECTED]>,
"Rhino" <[EMAIL PROTECTED]> writes:
>> The chief advantage of 'SET', as far as I can tell from the manual, is
> that
>> it lets you control the specific values which can be in a column without
>> having to write application lookups to verify that the value you are
>
Hi.
Following documentation, we can see:
"ENUM and SET columns provide an efficient way to define columns
that can contain only a given set of values."
http://dev.mysql.com/doc/mysql/en/constraint_enum.html
But carefully read
http://dev.mysql.com/doc/mysql/en/SET.html
before y
See my remarks interspersed below.
Rhino
- Original Message -
From: "Andy B" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 5:09 PM
Subject: Re: column choices for certain data
> Hi...
>
> Thanks for the info/help here.
N
the matter...
tnx for the help...
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Andy B" <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 4:00 PM
Subject: Re: column choices for certain data
- Original Message -
From: "An
Oops, I meant to copy the list on this reply too.
Rhino
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Andy B" <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 4:00 PM
Subject: Re: column choices for certain data
>
> - O
Hi...
I have a db that I'm writing. It's for a business directory and one of the
fields/columns in the table needs to have a list of business types in it
(i.e. retail, auto, computer and so on). Since there may be more than one
category that a business fits under I was wondering if "SET" is the
