At this point, what you say you are doing should work, but 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.
Michael
Thomas McDonough wrote:
> 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 reading of the
>>> manual and mail archives tell me to do it like this:
>>>
>>> mysql> update listings set map= concat (ML, '.png') where ML<>'';
>>
>>
>> mysql> update listings set map= concat(ML, '.png') where ML<>'';
>> Lose the space between 'concat' and '('
>>
>>>
>>>
>>> but all I get is this:
>>>
>>> ERROR 1064 (42000): You have an error in your SQL syntax; check the
>>> manual that corresponds to your MySQL server version for the right
>>> syntax to use near '(ML, '.png') where ML<>''' at line 1
>>>
>>> What am I doing wrong?
>>>
>>> Tom
>>>
>>>
>>
>>
>
>
