QUERY question (group by) - please help
| From: | Damir Dezeljin | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | QUERY question (group by) - please help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-24754@lists.php.net to get a copy of this message | ||
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