Same here: F:\MySQL\bin>mysql -uroot -e "select count(distinct Host) from user \G" mysql *************************** 1. row *************************** count(distinct Host): 2
F:\MySQL\bin>mysql -v Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 3.23.39-nt Xi2 -----Original Message----- From: Stephen Abshire [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 7:21 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: count(distinct I am inclined to think (actually guess) it may be the version of MySQL you are using. I am using MySQL 3.23.39 and I am able to successfully execute: select count(distinct field) or select count(distinct(field)) I tried to make a quick check of the docs to see if a certain version was required but I was unable to find anything. ----Original Message Follows---- From: Ilic <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Re: count(distinct Date: Wed, 9 Jan 2002 14:54:12 +0100 Il Tue, 08 Jan 2002 13:23:09 -0500, Stephen Abshire andava dicendo... >>SELECT count(distinct ip) FROM pole_voti >> >>It does'nt work. Why ? >> >>PhpMyAdmin says: You have an error in your SQL syntax near >>'distinct ip) >>FROM pole_voti' at line 1 >I don't have MySQL on the computer I am on to test this but you >might try rewriting it this way: > >select count(distinct(ip)) from pole_voit Already done. It does'nt work to. Ilic. --------------------------------------------------------------------- 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 _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx --------------------------------------------------------------------- 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
