Resolving MySQL Error – FUNCTION CONCAT does not exist
Before I begin it’s worth nothing that this error is only a problem on certain versions of MySQL. The error in question is as follows:
[Err] 1305 - FUNCTION databasename.CONCAT does not exist
Let’s take a look at a very simple query that would result in this error appearing:
SELECT CONCAT ('foo', 'bar')
The Solution
The solution is an easy one. Simply remove the space after the word CONCAT. I’ve included below a revised (and working) version of the query from above.
SELECT CONCAT('foo', 'bar')
I think you’re spelling the function wrong. Should be GROUP_CONCAT(), not GROUP_CONTACT()
SELECT subject,GROUP_CONTACT(description)FROM assignment WHERE standard_id=’1′ AND section_id=’61’ AND assignment_date=’2015-06-30′ GROUP BY subject;
For above query , I am facing this error , what is the mistake,
#1305 – FUNCTION ssv.GROUP_CONTACT does not exist.
finally an answer that works
(but dont ask me why)
thanks Steve Marks