← Back to team overview

maria-discuss team mailing list archive

Re: New Question: COUNT not working on XAMPP

 

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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

References