List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 23 1999 3:00pm
Subject:Re: Modifying SET columns
View as plain text  
>Hi.
>
>On Sun, Aug 22, 1999 at 11:01:26PM -0400, andrian@stripped wrote:
>[...]
>> Again, I need the SET type in order to have multiple
>> selections. There might be other workarounds, but I haven't
>> discovered them yet.
>
>One other way is to have a second table with mulitiple values for each
>id. Some time ago there was a discussion about the advantages and
>disadvantages regarding this method and SETs. You may want to search
>in the mailing list archieve for it.
>
>A point against SETs was that you usually only want to use them if the
>set is kind of static (since adding and removing of values needs to
>change all records).
>
>Another method is to do not use a SET, but handle the string yourself
>(just knowing yourself which values are allowed). This may be easier
>to handle, probably is slower, because MySQL uses binary values
>internally for SETs.


Yes, ENUM and SET are faster than the same values represented as CHAR
or VARCHAR.

-- 
Paul DuBois, paul@stripped
Thread
Storing GIF\'s in MySQLGeocrawler.com18 Aug
  • Storing GIF\'s in MySQLsinisa18 Aug
  • Re: Storing GIF\'s in MySQLMartin Ramsch18 Aug
  • Re: Storing GIF\'s in MySQLUrb LeJeune18 Aug
    • Re: Storing GIF\'s in MySQLPaul DuBois18 Aug
    • Re: Storing GIF\'s in MySQLScott Hess18 Aug
      • Re: Storing GIF\'s in MySQLUrb LeJeune18 Aug
        • Re: Storing GIF\'s in MySQLVivek Khera18 Aug
        • Re: Storing GIF\'s in MySQLPaul DuBois18 Aug
          • Re: Storing GIF\'s in MySQLOliver Artelt18 Aug
            • Re: Storing GIF\'s in MySQLMartin Ramsch18 Aug
              • Re: Storing GIF\'s in MySQLOliver Artelt19 Aug
                • Re: Storing GIF\'s in MySQLPaul DuBois19 Aug
              • Re: Storing GIF\'s in MySQLTracy R Reed21 Aug
                • Re: Storing GIF\'s in MySQLsinisa21 Aug
      • Re: Storing GIF\'s in MySQLPaul DuBois18 Aug
    • Re: Storing GIF\'s in MySQLScott Hess18 Aug
    • Re: Storing GIF\'s in MySQLRonald Beck19 Aug
      • Re: Storing GIF\'s in MySQLPaul DuBois19 Aug
        • Re: Storing GIF\'s in MySQLPeter J. Schoenster19 Aug
          • Re: Storing GIF\'s in MySQLMartin Ramsch19 Aug
            • Re: Storing GIF\'s in MySQLBenjamin Pflugmann20 Aug
          • importing text file with mysqlimportBob C. Ruddy22 Sep
            • Re: importing text file with mysqlimportBob Kline22 Sep
              • Re: importing text file with mysqlimportBob Kline22 Sep
              • Re: importing text file with mysqlimportBob C. Ruddy22 Sep
                • Re: importing text file with mysqlimportMartin Ramsch23 Sep
                  • Re: importing text file with mysqlimportPaul DuBois23 Sep
                    • Re: importing text file with mysqlimportMartin Ramsch23 Sep
                      • Re: importing text file with mysqlimportPaul DuBois23 Sep
                        • Re: importing text file with mysqlimportPaul DuBois23 Sep
    • Re: Storing GIF's in MySQLCarsten H. Pedersen19 Aug
      • Re: Storing GIF's in MySQLMartin Ramsch20 Aug
  • Re: Storing GIF\'s in MySQLDavid Biro [DaV3|D3]19 Aug
Re: Storing GIF\'s in MySQLFrank Piwarski19 Aug
  • Re: Storing GIF\'s in MySQLStephen Johnston19 Aug
    • Re: Storing GIF\'s in MySQLshane19 Aug
    • Re: Storing GIF\'s in MySQLThimble Smith19 Aug
    • Re: Storing GIF\'s in MySQLaaron abelard19 Aug
Re: Storing GIF\'s in MySQLRaymond Gubala19 Aug
RE: Storing GIF's in MySQLHoward Lin20 Aug
  • Re: Storing GIF's in MySQLBenjamin Pflugmann20 Aug
  • RE: Storing GIF's in MySQLVivek Khera20 Aug
    • Re: Storing GIF's in MySQLMartin Ramsch20 Aug
  • Failing to unsubscribeJoel Palenychka22 Aug
  • Modifying SET columnsAndrian Pervazov22 Aug
    • Re: Modifying SET columnsPaul DuBois23 Aug
  • Re: Modifying SET columnsAndrian Pervazov23 Aug
    • Re: Modifying SET columnsBenjamin Pflugmann23 Aug
      • Re: Modifying SET columnsPaul DuBois23 Aug
  • Re: Modifying SET columnsGerald Clark23 Aug
  • Odd increments with mysql and php3.Matt Duggan24 Aug
    • Odd increments with mysql and php3.sinisa25 Aug
Re: Modifying SET columnsDave Kaufman23 Aug
  • Re: Modifying SET columnsPaul DuBois23 Aug