Sorry if this mail already arived to the list (I'm not sure if my posting
was sucesfull, because I had problems with my mail server). The past
posting:
Hi.
I want to calculate how many rows my 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:
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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
