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