- Original Message -
From: "Stembridge, Michael" <[EMAIL PROTECTED]>
To:
Sent: Friday, March 25, 2005 5:23 PM
Subject: SET question - @ or @@?
> While I was RTFM to find out how long SET variables last, I noticed that
my
> book uses @@VarName but the sample code I'm using has @ VarName
At 10:23 -0600 3/25/05, Stembridge, Michael wrote:
While I was RTFM to find out how long SET variables last, I noticed that my
book uses @@VarName but the sample code I'm using has @ VarName. I didn't
see a reference to the single @ in the SET section of my book.
So, what is the difference bet
"Thalis A. Kalfigopoulos" writes:
>So in your case that you want to add "d" to a tuple that is "a,b,c" you do
>UPDATE table SET set_val=15 WHERE my_cond;
>since 15 is in binary (the leftmost '1' is the flag that tells mysql to
>add the "d" in your set)
>
>does it make any sense?
Yes,
This is a reply to the SET column UPDATE question (I deleted to e-mail, oups!).
The question was that you have a column of type SET and value ("a,b,c") and you want
to make this ("a,b,c,d")
In the __MySQL MANUAL__ it says that the SET type is actually stored numerically and
in particular "with
