|List:||General Discussion||« Previous MessageNext Message »|
|From:||Gerald Clark||Date:||August 23 1999 1:04pm|
|Subject:||Re: Modifying SET columns|
|View as plain text|
Benjamin Pflugmann wrote: > > 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. > What I have done in the past is change the column to a char, change the the values I wanted changed, then change the column back to a set.