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).
No space allowed after the function and the parens:
Bad Good
--- ----
MIN (foo) MIN(foo)
MAX (foo) MAX(foo)
COUNT (*) COUNT(*)
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 1 days, processed 18,902,837 queries (190/sec. avg)
---------------------------------------------------------------------
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
