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ørn 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 > > =========================================================== > > ' 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 > --------------------------------------------------------------------- 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
