On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote:
> 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
Try count(*), max(column) and min(column). It probably doesn't accept
the space you put in between there.
Greetz, Peter
--
Monopoly http://www.dataloss.nl/monopoly.html
---------------------------------------------------------------------
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
