Hi.
Maybe this isn't the correct list for asking the below question (if
so sorry ;) ).
I want to calculate how many rows my MySQL query which uses 'GROUP BY'
returns.
The query:
----
SELECT <something>
FROM test
WHERE (kid=1) OR (kid=2) OR (kid=4)
GROUP BY cid,aid;
----
Is it posible to get number of rows with such a query from MySQL v3.23.49?
If it isn't posible ... is it posible in MySQL 4.x?
I think a lot about this problem and I realize only the following
solution (to avoid returning a lot of rows in PHP):
CREATE TEMPORARY TABLE t (i INT);
INSERT INTO t (i) SELECT aid FROM <the_query_above>
SELECT COUNT(*) FROM t;
DROP TABLE t;
But this isn't so elegant.
I want to do so on data generated by:
----
CREATE TABLE test (
kid INT,
aid INT,
cid INT
);
INSERT INTO test
(kid, aid, cid) VALUES
( 1, 0, 1),
( 2, 2, 2),
( 1, 3, 2),
( 2, 3, 2),
( 4, 4, 2),
( 4, 0, 3),
( 3, 3, 4),
( 4, 3, 4);
----
Regards,
Dezo
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
