InterBase (29)
MS-SQL (63)
mysql (163)
Oracle (327)
Exchange Links
About this site
concat () function to concatenate 2 strings in mysql does not exist
23 comments. Current rating: 
(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 | ||
 |  |
|
||||||||
Comments:
| You are on page 1 of 2, other pages: [1] 2 | ||
| ||
|
Thanks - that was very helpful to me here in Boston.
| ||
| ||
|
i wanna very thank you for the answer.
| ||
| ||
|
Oh mad.
Thanks you very much. I'm nearly sick with the error 'FUNCTION tablename.ROUND does not exist' ... | ||
| ||
|
Thank you.....A very helpful tip....saved my day.
| ||
| ||
|
Huray, thanks to you my first steps into SQL were not a total disaster :)
| ||
| ||
|
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.
| ||
| ||
|
Dude... thank you very much..
| ||
| ||
|
Dude... thank you very much..
| ||
| ||
|
THX - I own you a beer ;)
| ||
| ||
|
Thanks very much, it helped me with a stupid error I got:
which I found difficult to identify (since I am a C++ programmer). | ||
| ||
|
Thank you. It is really helpfull.
| ||
| ||
|
thx for the info
| ||
| ||
|
Still helpful! A nextline-character i.s.o. a space had the same effect.
| ||
| ||
|
Thank you so much: it's a very helpful tip. I saved a lot of time due your post :)
| ||
| ||
|
Thanks, me sirvio de mucho.
| ||
| You are on page 1 of 2, other pages: [1] 2 |
