Re: update and concat

[Michael Stassen]

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 following 
it. This helps the MySQL parser distinguish between function calls and 
references to tables or columns that happen to have the same name as a 
function. Spaces around function arguments are permitted, though."

Michael
Thomas McDonough wrote:
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




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update and concat

[Thomas McDonough]

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




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update and concat

[Michael Stassen]

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



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update and concat

[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 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



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update and concat

[gerald_clark]

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


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update and concat

[Roger Baklund]

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:
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?
Don't use a space between 'concat' and the parantheses, it is a function 
call:

update listings set map= concat(ML, '.png') where ML<>'';
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

update and concat

[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 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]