Error while running query
I am getting below error while running query: "Error Code: 1630. FUNCTION employees.count does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual". What could be issue?
1 answers ( 0 marked as helpful)
Hi Nishit!
Thanks for reaching out.
In your code you are using the function COUNT() but you put a space after it like this: COUNT () and MySQL interpret it as a user-created function and not the built in function. And since there is no such user function you get this error. You can simply beautify your code with Ctrl + B command and it will remove these extra spaces from your code and also will make your code more readable. Then, the query will work successfully.
Hope this helps.
Best,
Tsvetelin