>>>>> "Scott" == Scott Liu <scott@stripped> writes:
Scott> ChinaConnect wrote:
>> 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?
Scott> I noticed that, too. What I did is to "select id from sometable" and then
Scott> count the
Scott> distinct id in the application program. Can anyone give us a better way to do
Until MySQL 3.23:
CREATE TABLE tmp_table_$$ (distinct_value CHAR(x), PRIMARY KEY (distinct_value));
INSERT IGNORE INTO tmp_table SELECT distinct_value FROM table_name;
SELECT count(*) from tmp_table_$$;
drop table tmp_table_$$;