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:[EMAIL PROTECTED]] >Sent: Friday, January 25, 2002 2:02 PM >To: Matthew Walker; [EMAIL PROTECTED] >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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php