List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 23 1999 4:52am
Subject:Re: Modifying SET columns
View as plain text  
At 11:17 PM -0400 8/22/99, Dave Kaufman wrote:
>Andrian Pervazov <andrian@stripped> 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.
>
>Hi Andrian,
>
>try altering the table to add the "darkred" value (leaving "red" in place),
>then update tablename set color="darkred" where color="red"
>
>and then alter the table again, removing "red" from the set.


This would be easier if the column were an ENUM, because then you
could test the value to make sure it was just "red".  But since it's
a SET, it could contain "red" anywhere in the set.  Perhaps a job
for REPLACE(), and that might work well since "red" doesn't occur
as a substring of any of the other colors in the example.

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