Re: how to add to a set

2001-02-15 Thread Cindy
Bob Hall writes: What I want to do is something like this...a set variable in a table has a current value of "a,b,c" and I want to add the value "d" to it so the new value is now "a,b,c,d". The type is already defined as setval SET ('a', 'b', 'c', 'd', 'e', 'f') Ma'am, by variable, do

how to add to a set

2001-02-12 Thread Cindy
OK, is there an easy way to ADD a value to a set type without having to enumerate all that's there already? I've looked through http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET but it doesn't say anything about adding values to the current set. It rather looks like