It would appear that you are putting spaces between Count and the bracket
which as far as I can tell will not work hence try count(*) etc...
Chris Thorpe
----- Original Message -----
From: "Antonio Ortega Sancho" <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Sent: Friday, September 07, 2001 8:28 AM
Subject: problem with count (*) max (*) min (*)
> I'm trying to do select count (*) from table..... but it doesn't work
>
> ERROR 1064: You have an error in your SQL syntax near '(*) from
pendientes'
> at line 1
>
> Same happens with max (column) and min (column).
>
> Do I have to install anything else or is something wrong. I'm using
> redhat 7.0 with the mysql that comes with this distribution
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
