Silvério Santos schrieb: > probier mal folgendes (ungetestet): > > SELECT day, COUNT(accepted=0) AS countAccept, COUNT(accepted=1) AS > countReject FROM mails GROUP BY day ORDER BY day;
Nee, nee. Das gibt select nicht her. mysql> select count(accepted=0) from mails; +-------------------+ | count(accepted=0) | +-------------------+ | 11723394 | +-------------------+ 1 row in set (6 min 25.03 sec) mysql> select count(accepted=1) from mails; +-------------------+ | count(accepted=1) | +-------------------+ | 11723394 | +-------------------+ 1 row in set (13.78 sec) Ich mach's jetzt in der Applikation. Zwei Selects oder zwei Subselects kommt von der Laufzeit eh aufs selbe raus. Danke an alle, -martin -- Schmitt Systemberatung Linux/UNIX Giessener Str. 18 Internet/Intranet 35415 Pohlheim/Germany E-Mail Infrastructure http://www.scsy.de Antispam/Antivirus
signature.asc
Description: OpenPGP digital signature
-- ---------------------------------------------------------------------------- PUG - Penguin User Group Wiesbaden - http://www.pug.org
