Spaces on either side of = are not a problem, but you must not put a space
between the name of a function and the opening parenthesis. From the manual
<http://dev.mysql.com/doc/mysql/en/Functions.html>, "Note: By default, there
must be no whitespace between a function name and the parenthesis following
it. This helps the MySQL parser distinguish between function calls and
references to tables or columns that happen to have the same name as a
function. Spaces around function arguments are permitted, though."
Michael
Thomas McDonough wrote:
> Someone else suggested that I remove all spaces before and after = and
> between CONCAT and (...). This worked. Too bad the manual is not more
> specific.
> Thanks for your concern,
> Tom
>
> On Nov 30, 2004, at 7:14 PM, Michael Stassen wrote:
>
>> 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
>>>>>
>>>>>
>>>>
>>>>
>>
>
>
