doesn't.
We cannot guess what's wrong. Please enter your command,
UPDATE listings SET map = CONCAT(ML, '.png') WHERE ML <> '';
get your error message, and then copy/paste the whole thing into your
next message. That way, someone should spot the problem.
That did not do it. I'm still getting the same error message (?)
Tom
On Nov 30, 2004, at 2:09 PM, gerald_clark wrote:
Thomas McDonough wrote:
I'm trying to set all the values of column 'map' to the value of
column ML and '.png'. My intuition and an extensive r
I'm trying to set all the values of column 'map' to the value of column
ML and '.png'. My intuition and an extensive reading of the manual and
mail archives tell me to do it like this:
mysql> update listings set map= concat (ML, '.png') where ML<>'';
but all I get is this:
ERROR 1064 (42000): Y
