Need more information... what exactly is Our older version, and
what exactly is the newest version of MySql, without this it's hard
to know what issues you may be facing... I imagine you are on 4.0.n
for the old and 4.1.n for the new... but we can't really tell from
the information you
Hello,
We have installed the newest version of MySql and cannot get it to play nice
with French characters. Our older version worked fine. The problem may (or
may not) be that when we put the dump into the new database(yes its default
charset is Utf8) the default character set for the table is
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 between @@ and @?
Thank you.
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
- Original Message -
From: Stembridge, Michael [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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
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
"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, but