DelphiFAQ Home Search:
General :: Databases :: mysql
General information about mysql - how to get around the differences between version 3.33 an 4, how to do stuff that you think you need a nested query for etc.

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

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

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
 

Generated 8:00:37 on Jun 26, 2019