Databases InterBase (29) MS-SQL (63) mysql (163) Oracle (327)
Exchange Links About this site Links to us
|
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 | |
anonymous
|
 |
|
Thanks - that was very helpful to me here in Boston.
|
|
lcilleful from Japan
|
 |
|
i wanna very thank you for the answer.
|
|
anonymous from Vietnam
|
|
|
Oh mad.
Thanks you very much.
I'm nearly sick with the error 'FUNCTION tablename.ROUND does not exist' ...
|
|
orgutz@yahoo.com from Dewey, United States
|
 |
|
Thank you.....A very helpful tip....saved my day.
|
|
anonymous from United States
|
|
|
Huray, thanks to you my first steps into SQL were not a total disaster :)
|
|
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.
|
|
anonymous from United States
|
|
|
Dude... thank you very much..
|
|
anonymous from United States
|
|
|
Dude... thank you very much..
|
|
anonymous from Poland
|
|
|
THX - I own you a beer ;)
|
|
anonymous from Germany
|
 |
|
Thanks very much, it helped me with a stupid error I got:
Error: MySQL says: FUNCTION database_name.round does not exist |
which I found difficult to identify (since I am a C++ programmer).
|
|
anonymous from China
|
|
|
Thank you. It is really helpfull.
|
|
anonymous from Canada
|
|
|
thx for the info
|
|
anonymous
|
 |
|
Still helpful! A nextline-character i.s.o. a space had the same effect.
|
|
asleo from Italy
|
 |
|
Thank you so much: it's a very helpful tip. I saved a lot of time due your post :)
|
|
www.chistes8.com from Buenos Aires, Argentina
|
 |
|
Thanks, me sirvio de mucho.
|
You are on page 1 of 2, other pages: [1] 2 |
|