Re: update and concat

2004-12-01 Thread Thomas McDonough
, 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

update and concat

2004-11-30 Thread Thomas McDonough
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 this: ERROR 1064 (42000): You

Re: update and concat

2004-11-30 Thread Thomas McDonough
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