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