[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: update and concat
From:       Thomas McDonough <mcdonough () stantonwoods ! com>
Date:       2004-11-30 19:18:12
Message-ID: 93DD866C-4304-11D9-9FDD-000D93B6C014 () stantonwoods ! com
[Download RAW message or body]

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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]