List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 25 2002 9:34pm
Subject:RE: MySQL Checkbox table field
View as plain text  
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

Thread
Re: MySQL Checkbox table fieldVernon A Webb25 Jan
Re: MySQL Checkbox table fieldMichael Collins25 Jan
  • Re: MySQL Checkbox table fieldDan Nelson25 Jan
    • Re: MySQL Checkbox table fieldMichael Collins25 Jan
      • Re: MySQL Checkbox table fieldDan Nelson25 Jan
        • Re: MySQL Checkbox table fieldMichael Collins25 Jan
          • Re: MySQL Checkbox table fieldDan Nelson25 Jan
            • Re: MySQL Checkbox table fieldMichael Collins25 Jan
RE: MySQL Checkbox table fieldTodd Williamsen25 Jan
RE: MySQL Checkbox table fieldJames E. Hicks III25 Jan
RE: MySQL Checkbox table fieldMatthew Walker25 Jan
  • RE: MySQL Checkbox table fieldPaul DuBois25 Jan
Re: MySQL Checkbox table fieldDavid Shields25 Jan
RE: MySQL Checkbox table fieldMatthew Walker25 Jan
  • RE: MySQL Checkbox table fieldPaul DuBois25 Jan