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?
7 messages in com.mysql.lists.mysqlRe: update and concat
