7 messages in com.mysql.lists.mysqlRe: update and concat
FromSent OnAttachments
Thomas McDonough30 Nov 2004 10:02 
Roger Baklund30 Nov 2004 10:59 
gerald_clark30 Nov 2004 11:09 
Thomas McDonough30 Nov 2004 11:17 
Michael Stassen30 Nov 2004 16:14 
Thomas McDonough01 Dec 2004 06:31 
Michael Stassen01 Dec 2004 08:22 
Subject:Re: update and concat
From:Thomas McDonough (mcdo@stantonwoods.com)
Date:12/01/2004 06:31:44 AM
List:com.mysql.lists.mysql

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