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