Re: update and concat

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 , "Note: By default, there must be no whitespace between a function name and the parenthesis f

Re: update and concat

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 doe

Re: update and concat

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 sho

Re: update and concat

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 arch

Re: update and concat

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 list

Re: update and concat

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<>''; but all I get is thi