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 <nore...@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 >
_______________________________________________ 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
