SELECT COUNT

am 27.09.2002 14:16:49 von mfuhrman

Hello All,

I seem to be running into a very strange problem.

In the mySQL command line interface I issue SELECT COUNT (*) FROM
test; and get --> ERROR 1064: You have an error in your SQL syntax
near '(*) from test' at line 1.

Below is the test table:

CREATE TABLE test
(
ID INTEGER AUTO_INCREMENT,
PRIMARY KEY (ID),
szName VARCHAR (30)
)

Any suggestions?

ENetArch

===========================================================

' Keywords:
' mySQL, SELECT, COUNT
' ERROR 1064:
' ERROR: Microsoft OLE DB Provider for ODBC Drivers -2147217911

' Environment:
' Server - Windows NT 4.0 Server, 64 meg, Pentium II 400 mhz
' mySQL - 3.23.51 - NT

------------------------------------------------------------ ---------
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SELECT COUNT

am 27.09.2002 14:32:00 von Rafal Jank

On Fri, 27 Sep 2002 08:16:49 -0400
"Michael J. Fuhrman" wrote:

> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the mySQL command line interface I issue SELECT COUNT (*) FROM
> test; and get --> ERROR 1064: You have an error in your SQL syntax
> near '(*) from test' at line 1.
>
You shouldn't have this space between COUNT and (*).

--
_/ _/ _/_/_/ ----- Rafa³ Jank rjank@wp-sa.pl -----
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
_/ _/ _/ --------==* http://szukaj.wp.pl *==----------

------------------------------------------------------------ ---------
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SELECT COUNT

am 27.09.2002 14:34:59 von lindahl

Try without the blank

count(*) instead of count (*)

Easy mistake to make i guess, but remember that count() is a function and
should have brackets.

Regards
Torbj=F8rn

On Fri, 27 Sep 2002, Michael J. Fuhrman wrote:

> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the mySQL command line interface I issue SELECT COUNT (*) FROM
> test; and get --> ERROR 1064: You have an error in your SQL syntax
> near '(*) from test' at line 1.
>
> Below is the test table:
>
> CREATE TABLE test
> (
> ID INTEGER AUTO_INCREMENT,
> PRIMARY KEY (ID),
> szName VARCHAR (30)
> )
>
> Any suggestions?
>
> ENetArch
>
> ==================== =====
==================== =====3D=
==========
>
> ' Keywords:
> ' mySQL, SELECT, COUNT
> ' ERROR 1064:
> ' ERROR: Microsoft OLE DB Provider for ODBC Drivers -2147217911
>
> ' Environment:
> ' Server - Windows NT 4.0 Server, 64 meg, Pentium II 400 mhz
> ' mySQL - 3.23.51 - NT
>
>
>
> ------------------------------------------------------------ ---------
> 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
> To unsubscribe, e-mail sql.com>
> 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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: SELECT COUNT

am 27.09.2002 14:34:59 von lindahl

Re: SELECT COUNT

am 27.09.2002 14:36:32 von Joseph Bueno

Michael J. Fuhrman wrote:
> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the mySQL command line interface I issue SELECT COUNT (*) FROM
> test; and get --> ERROR 1064: You have an error in your SQL syntax
> near '(*) from test' at line 1.
>
> Below is the test table:
>
> CREATE TABLE test
> (
> ID INTEGER AUTO_INCREMENT,
> PRIMARY KEY (ID),
> szName VARCHAR (30)
> )
>
> Any suggestions?
>
> ENetArch
>
> ===========================================================
>
> ' Keywords:
> ' mySQL, SELECT, COUNT
> ' ERROR 1064:
> ' ERROR: Microsoft OLE DB Provider for ODBC Drivers -2147217911
>
> ' Environment:
> ' Server - Windows NT 4.0 Server, 64 meg, Pentium II 400 mhz
> ' mySQL - 3.23.51 - NT
>
>
>

Hi,

Try without a space between 'COUNT' and '(*)'.

Regards
--
Joseph Bueno

------------------------------------------------------------ ---------
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 bugs-thread12620@lists.mysql.com
To unsubscribe, e-mail

Re: SELECT COUNT

am 27.09.2002 14:36:32 von Joseph Bueno

Re: SELECT COUNT

am 27.09.2002 14:44:04 von andy thomas

On Fri, 27 Sep 2002, Michael J. Fuhrman wrote:

> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the mySQL command line interface I issue SELECT COUNT (*) FROM

The correct syntax is SELCT COUNT(*) ie, there's no space between SELECT
and the (*).

Andy

------------------------------------------------------------ ---------
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 bugs-thread12621@lists.mysql.com
To unsubscribe, e-mail

Re: SELECT COUNT

am 27.09.2002 14:44:04 von andy thomas

re: SELECT COUNT

am 27.09.2002 15:03:02 von Egor Egorov

Michael,
Friday, September 27, 2002, 3:16:49 PM, you wrote:

MJF> I seem to be running into a very strange problem.

MJF> In the mySQL command line interface I issue SELECT COUNT (*) FROM
MJF> test; and get --> ERROR 1064: You have an error in your SQL syntax
MJF> near '(*) from test' at line 1.

MJF> Below is the test table:

MJF> CREATE TABLE test
MJF> (
MJF> ID INTEGER AUTO_INCREMENT,
MJF> PRIMARY KEY (ID),
MJF> szName VARCHAR (30)
MJF> )

MJF> Any suggestions?

Remove space between COUNT and (*)

--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ Egor.Egorov@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com

------------------------------------------------------------ ---------
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
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php