there is an error in your sql statement :
your origin sql is:SELECT COUNT (*) FROM test;
you should delete the space between 'count' and '(*)'.
the correct sql is :SELECT COUNT(*) FROM test;
======= ��=======
>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 <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
= = = = = = = = = = = = = = = = = = = =
������������������
��
����������������muyuan
����������������[EMAIL PROTECTED]
��������������������2002-10-07
---------------------------------------------------------------------
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
