>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perrin >Harkins >Sent: Thursday, July 31, 2008 11:25 AM >To: Jerry Schwartz >Cc: mysql@lists.mysql.com >Subject: Re: SET vs. ENUM > >On Thu, Jul 31, 2008 at 9:46 AM, Jerry Schwartz ><[EMAIL PROTECTED]> wrote: >> Other than the fact that an ENUM can have many more values than a SET, >is >> there any particular reason to choose one over the other? > >The only use for ENUM is to make your data smaller. It offers no >protection against illegal values and can't be updated without copying >the table. If you want to constrain values, a better approach is to >make your tables InnoDB and use a lookup table with a foreign key >constraint. > [JS] Too late, I inherited this. There are a LOT of places where foreign key restraints (and cascading deletes) would save a lot of programming.
I do, however, make use of full-text indexing. >- Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]