F:\MySQL\bin>mysql -uroot -e "select distinct count(*) from user \G" mysql
*************************** 1. row ***************************
count(*): 4
Xi2 ('sE-'t�)
-----Original Message-----
From: Ilic [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 5:54 AM
To: [EMAIL PROTECTED]
Subject: Re: count(distinct
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
---------------------------------------------------------------------
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
