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

Databases
InterBase (28)
MS-SQL (5)
mysql (36)
Oracle (1)

Exchange Links

About this site

Links to us

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

8 comments. Current rating: 5 stars

(4 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

Comments:

2008-06-05, 12:28:22

anonymous

Thanks - that was very helpful to me here in Boston.

2008-06-13, 03:19:19

lcilleful from Japan

i wanna very thank you for the answer.

2008-07-10, 05:56:12

anonymous from Vietnam

Oh mad.
Thanks you very much.
I'm nearly sick with the error 'FUNCTION tablename.ROUND does not exist' ...

2008-09-26, 15:17:19

orgutz@yahoo.com from Dewey, United States

Thank you.....A very helpful tip....saved my day.

2008-11-18, 08:24:30

anonymous from United States

Huray, thanks to you my first steps into SQL were not a total disaster :)

2008-11-21, 10:16:44

anonymous from United States

Very helpful, I have been using CONCAT() for a while but I guess I had never left a space after it. After chasing that error for two days I found this post Thank you very much.

2008-12-17, 14:06:17

anonymous from United States

Dude... thank you very much..

2008-12-17, 14:06:25

anonymous from United States

Dude... thank you very much..

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.

It seems that you are from Los Angeles, US . Info/ Feedback on this	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:
Add a picture: 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.


	Search: