Re: query works on mysql windows version ,but not on mysql solaris version

[Jay Pipes]

You will have to do something like:

CREATE TEMPORARY TABLE tmp_counts (
date DATE NOT NULL
, errcode VARCHAR(25) NOT NULL
, cnt INT NOT NULL
, INDEX (errcode));

INSERT INTO tmp_counts
SELECT date,errcode,count(errcode) cnt from websec
where errcode in ('WIP663','WIP701')
GROUP BY date,errcode;

SELECT errcode, avg(tbl.cnt) from tmp_counts
GROUP BY errcode;

DROP TABLE tmp_counts;

Hope this helps

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com