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