List:General Discussion« Previous MessageNext Message »
From:Ed Carp Date:March 20 1999 6:49pm
Subject:Re: Help with query, plz
View as plain text  
>On Sa, 1999-03-20 11:25:51 -0700, Thimble Smith wrote:
>> COUNT(DISTINCT(...)) doesn't work in MySQL (yet).  Try this:
>>
>> SELECT COUNT(*) FROM table GROUP BY ip;
>
>Not again!  I really wonder why people keep on giving this wrong
>answer ...?


This is really funny, especially because...

>  SELECT DISTINCT field FROM table;


...isn't right either!  It gives a table of results, not the count, which is
what the original poster wanted.

Sorry, but thanks for playing.

Thread
Help with query, plzMichal Ludvig20 Mar
  • Re: Help with query, plzThimble Smith20 Mar
    • Re: Help with query, plzMichal Ludvig20 Mar
    • Re: Help with query, plzMartin Ramsch20 Mar
Re: Help with query, plzEd Carp20 Mar
  • Re: Help with query, plzMichal Ludvig20 Mar
    • Re: Help with query, plzThimble Smith20 Mar
Re: Help with query, plzEd Carp20 Mar
  • Re: Help with query, plzMartin Ramsch20 Mar
Re: Help with query, plzEd Carp20 Mar