List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 16 1999 11:21pm
Subject:Re: How to delete a member from a SET column
View as plain text  
On Thu, 1999-09-16 16:04:31 -0400, James Manning wrote:
> Out of curiosity, is the "right way" then to always keep an id -> name
> table separately and join that in (on the id) to find rows with
> properties of a certain type?  or are there better approaches?

As far as I know, in relational database systems like MySQL this
actually is _the_ way to go, yes.

It may seem to be waste of storage, but in most cases the much easier
handling of data does pay.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
How to delete a member from a SET columnBenjamin Pflugmann7 Jul
  • Re: How to delete a member from a SET columnMartin Ramsch15 Sep
    • Re: How to delete a member from a SET columnJames Manning15 Sep
      • Re: How to delete a member from a SET columnMartin Ramsch16 Sep
        • Re: How to delete a member from a SET columnMartin Ramsch16 Sep
          • Re: How to delete a member from a SET columnJames Manning17 Sep
            • Re: How to delete a member from a SET columnMartin Ramsch17 Sep
              • Re: How to delete a member from a SET columnJames Manning17 Sep
                • Re: How to delete a member from a SET columnMartin Ramsch17 Sep
                  • placeholdersjice17 Sep
                    • Re: placeholdersBob Kline17 Sep
                  • Re: How to delete a member from a SET columnJames Manning17 Sep
        • Re: How to delete a member from a SET columnJames Manning17 Sep
          • Re: How to delete a member from a SET columnMartin Ramsch17 Sep