Try

SELECT COUNT(*) FROM repairs;

-- ie. no SPACE-character after "COUNT". Built-in functions don't accept this (but Stored Functiosn do as far as I remember).. 



-- Peter
-- Webyog

On Fri, Feb 12, 2016 at 3:55 PM, AskMonty KB <noreply@askmonty.org> wrote:
Hello,

A new question has been asked in "SQL Commands" by styxlawyer. Please answer it at http://mariadb.com/kb/en/count-not-working-on-xampp/ as the person asking the question may not be subscribed to the mailing list.

--------------------------------
I have just installed XAMPP version 7.0.2 which incorporates MariaDB. I have added a table called repairs to the test database and it works fine with various PHP pages I have written. However, when trying to use a simple query like:

SELECT COUNT (*) FROM repairs

I get the following error message:

#1630 - FUNCTION test.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

This happens in both phpMyadmin and in PHP pages which are accessing the database.
--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/count-not-working-on-xampp/

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp