DelphiFAQ Home Search:

concat () function to concatenate 2 strings in mysql does not exist

 

comments23 comments. Current rating: 5 stars (11 votes). Leave comments and/ or rate it.

Question:

I want to concatenate 2 strings in my mysql database and I get the error message:
ERROR 1305 (42000): FUNCTION support.concat does not exist
How is that possible?

Answer:

In some mysql versions, you MUST NOT have a space after the function name. Try concat() instead of concat ().

mysql> update s_resources set resource_path = concat (resource_path, '/');
ERROR 1305 (42000): FUNCTION support.concat does not exist


mysql> update s_resources set resource_path = concat(resource_path, '/');
Query OK, 6 rows affected (0.00 sec)
Rows matched: 6  Changed: 6  Warnings: 0

Content-type: text/html

Comments:

You are on page 2 of 2, other pages: 1 [2]
2010-01-25, 03:16:24
anonymous from India  
rating
THANKS A LOT
2010-02-25, 17:37:49
anonymous from United States  
U the man!!! thank you very much!! saved my day...
2010-05-24, 09:10:57
Arboles from Spain  
Ufff, tron, muchas gracias por la respuesta!!
2011-10-05, 13:45:12
Irving from Chippewa Falls, United States  
rating
Thank you for hel me
2011-11-04, 03:09:48
Arnaldo from Italy  
Thanks a lot! This issue was driving me crazy before reading your reply.
2012-06-12, 14:23:37
abrown from United States  
rating
Genius! That was it!
2012-06-22, 07:18:59
anonymous from France  
Thank you, it helped
2012-06-22, 07:19:26
SaÏb from France  
Thank you, it helped
You are on page 2 of 2, other pages: 1 [2]

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: