day, February 20, 2001 10:12
Subject: ENUM or not ENUM?
> Hello
>
> I have situation where I can't decide whether to use ENUM type.
> Here is a situation:
> table contains records about CarID and its colour(s). Each CarID is
allowed to have more than one colour such as red, g
check out the "set" type instead of enum.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Column_types
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET
-tcl.
On Tue, 20 Feb 2001, [KOI8-R] "îÉËÏÌÉÎ óÅÒÇÅÊ" wrote:
> Hello
>
> I have situatio
Hello
I have situation where I can't decide whether to use ENUM type.
Here is a situation:
table contains records about CarID and its colour(s). Each CarID is allowed to have
more than one colour such as red, green, blue. CarID may have just one colour.
This is the code I would use to creat