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
>>
>>
>
>
