At 14:26 -0700 1/25/02, Matthew Walker wrote:
>Say I have a similar enum field that shows up in many tables. Right now,
>if I want to change it, I have to change it everywhere. What I'd like is
>a way to have a 1 column table that contains a list of the possible
>values for the enum field, and have the enum automatically build itself
>based on that table.
No, you can't do that. It wouldn't be too hard to write a program
that examined the table and generated the appropriate ALTER TABLE
statements to change the other tables, though.
>Matthew Walker
>Ecommerce Project Manager
>Mountain Top Herbs
>
>
>-----Original Message-----
>From: Paul DuBois [mailto:paul@stripped]
>Sent: Friday, January 25, 2002 2:02 PM
>To: Matthew Walker; mysql@stripped
>Subject: RE: MySQL Checkbox table field
>
>At 14:04 -0700 1/25/02, Matthew Walker wrote:
>>This brings to mind a question I've had for a while. Is there any way
>to
>>automatically build and update an enum based on another very simple (1
>>column) table?
>
>What does that mean, exactly?
>
>>
>>Matthew Walker
>>Ecommerce Project Manager
> >Mountain Top Herbs
