Re: Perl or Mysql to store multiple choices?

Depending on the number of options (64 or less), you might also consider the SET datatype

Personally, I don't like strings to store a bunch of data in the database - it kind of defeats the purpose of using a database.

"What should it profit a man, if he should win a flame war, yet lose his cool?"

Comment on Re: Perl or Mysql to store multiple choices?

Replies are listed 'Best First'.
Re^2: Perl or Mysql to store multiple choices? by punch_card_don (Curate) on Mar 29, 2007 at 22:03 UTC
After reading the link provided, I think this verges on genius for my application. Thanks. The only real potential for problems I see is what happens if the options change down the road - looks like with this I'm into modifying the table. Forget that fear of gravity, Get a little savagery in your life.	[reply]
Re^3: Perl or Mysql to store multiple choices? by Joost (Canon) on Mar 29, 2007 at 22:17 UTC
I think you can do an alter table and specify different elements in the set and keep the elements that are in the old and the new set - I know you can add elements with alter table. "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]