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 variabl

Re: how to add to a set

2001-02-13 Thread Bob Hall
>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 l

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 a