Re: ENUM or not ENUM?

2001-02-19 Thread Rolf Hopkins
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

Re: ENUM or not ENUM?

2001-02-19 Thread tc lewis
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

ENUM or not ENUM?

2001-02-19 Thread "Николин Сергей"
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