List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 22 1999 11:50pm
Subject:Re: Modifying SET columns
View as plain text  
At 3:55 PM -0400 8/22/99, Andrian Pervazov wrote:
>Let's say I have a table where one of the fields is of the type SET, 
>with values
>SET('red','green',blue'). At some point I decide that 'red' should 
>be changed to
>'darkred'. I do it with the ALTER TABLE ... 
>SET('darkred','green','blue') statement.
>Now, I would normally expect that all the records which used to be 'red' would
>automatically become 'darkred'. However, they are all unset, i.e. 
>set to an empty
>value.


Why do you expect that?

-- 
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