> -----Original Message----- > From: Jay Blanchard [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 2:11 PM > > [snip] > Apparently, "SELECT COUNT (*) FROM ...." is not valid syntax according > to mysql ? where as "SELECT COUNT(*) FROM ...." is ? > [/snip] > > call and the opening parentheses. I know that ANSI-92 SQL and > ANSI-99 SQL do > not have this requirement, but I think that the MySQL folks may > have looked > closely at other programming languages and found that function names are > almost immediately followed by the opening parentheses (is one just a > parenthesi? :) ). > > Is this a problem?
Not any longer - the first reply (use --ansi) solved the problem - thanks. rgds, Per Jessen, Zurich --------------------------------------------------------------------- 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