List:General Discussion« Previous MessageNext Message »
From:Scott Liu Date:March 12 1999 7:34pm
Subject:Re: select count distinct
View as plain text  

ChinaConnect wrote:

> Hi,
> In mysql, it doesn't look like you can do this:
> select count(distinct id) from sometable.
>
> If this is true, how would I count the number of times distinct ids occur?
>
>

I noticed that, too. What I did is to "select id from sometable" and then
count the
distinct id in the application program. Can anyone give us a better way to do
this?

Scott

> G
>
> ---------------------------------------------------------------------
> To request this thread, e-mail mysql-thread61@stripped
>
> To unsubscribe, e-mail the address in the List-Unsubscribe header.
> For additional commands, e-mail: mysql-help@stripped

Scott Liu
Software Developer
831 460 4300
.....................................................................

TAPESTRY.NET - On Target, Online Recruiting
111 Mission St. Santa Cruz, CA 95060

Visit our web sites at:
http://www.tapestry.net
http://www.asia-net.com      Bilingual Professionals
http://www.developers.net   Software Developers


Thread
AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsMicheal Mc Evoy11 Mar
  • one query for two identical tablesTao Liang3 Mar
    • RE: one query for two identical tablesNicolas Prade3 Mar
  • group by conditionsTao Liang5 Mar
    • Re: group by conditionssinisa6 Mar
      • accessing db while updating itTao Liang26 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsRobert Hazeltine11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
  • select count distinctChinaConnect11 Mar
    • Re: select count distinctChris12 Mar
    • Re: select count distinctScott Liu13 Mar
      • Re: select count distinctMichael Widenius15 Mar
  • Re: AUTO_INCREMENT Limits to 256 recordsChristian Mack12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsKevin P. O'Brien11 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp12 Mar
Re: AUTO_INCREMENT Limits to 256 recordsEd Carp13 Mar
Re: Bad handshake problem with java and MySQL 3.22.32Carlos Proal15 Feb