Re: Counting number of rows return from count(*)

[Jay Pipes]

Sorry, you need 4.1+ to use derived tables/subqueries.

You'll have to do:

CREATE TEMPORARY TABLE tmp_count
SELECT count( * )
FROM `4images_sessions_hist` sh
WHERE sh.session_user_id <> -1
GROUP BY FROM_UNIXTIME( sh.session_lastaction, '%Y-%m-%d %H' ) , sh.session_user_id, sh.session_ip;

SELECT COUNT( * ) AS rows FROM tmp_count;

DROP TABLE tmp_count;

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

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