List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:March 20 1999 6:25pm
Subject:Re: Help with query, plz
View as plain text  
COUNT(DISTINCT(...)) doesn't work in MySQL (yet).  Try this:

SELECT COUNT(*) FROM table GROUP BY ip;

Tim


On Sat, Mar 20, 1999 at 07:20:50PM +0100, Michal Ludvig wrote:
> INSERT INTO tabtmp SELECT DISTINCT ip FROM table
> and then querying that new table:
> SELECT COUNT(ip) FROM tabtmp
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