At 14:41 +0100 1/10/03, Damir Dezeljin wrote:
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?
You want both a list of rows, and a count of the number of rows -- with
a single query. That doesn't make sense, because those two things are
incompatible.
If it isn't posible ... is it posible in MySQL 4.x?
MySQL 4.x won't change the fundamental nature of the incompatibility.
The strategy you use below is reasonable.
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
