[thelist] mysql error using select to update
Paul Bennett
Paul.Bennett at wcc.govt.nz
Tue Jan 13 19:24:25 CST 2009
Apologies, my memory != correct.
This is the correct syntax for setting a var in mysql:
mysql> select @myvar := name from accounts where id = "1";
And to use the var:
mysql> update accounts set name = @myvar where id = "4";
If I answered a question correctly that Rudy didn't, I'm pretty sure either
A) the world is about to end
B) or this is all a dream and I'm about to wake up
;)
Paul
More information about the thelist
mailing list