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?
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.