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
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
supplying is
- 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] writes:
The chief advantage of 'SET', as far as I can tell
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
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
- Original Message -
From: Andy B [EMAIL PROTECTED
...
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: Andy B [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday
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.
No problem; that's what the list