problem with count (*) max (*) min (*)

2001-09-07 Thread Antonio Ortega Sancho
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

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Peter van Dijk
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

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Carl Troein
Antonio Ortega Sancho writes: I'm trying to do select count (*) from table. but it doesn't work Try count(*) instead. -- Carl Troein - CĂ­rdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Jeremy Zawodny
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

Re: problem with count (*) max (*) min (*)

2001-09-07 Thread Chris Thorpe
, 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