SixK wrote:
>
> Hello ,
>
> here is a strange result I obtain,
> could someone tell me if it's a bug or if my request is wrong
>
> I'd like to obtain the number of times the word 'liste' is found in
> column page and the number of times the word 'piece' is found, all in
> a single request...
>
> In the last example, it look like for the first row, the result of the first column
>is
> added in the result of the second one !
>
> I use this mysqld version on redhat 7.1 : 3.23.36-log
>
> mysql> select numObj,count(*)
> -> from ttywstats
> -> where login='jdalton'
> -> and page='liste'
> -> group by numObj;
> +--------+----------+
> | numObj | count(*) |
> +--------+----------+
> | 0 | 10 |
> +--------+----------+
> 1 row in set (0.02 sec)
>
> mysql> select numObj,count(*)
> -> from ttywstats
> -> where login='jdalton'
> -> and page='piece'
> -> group by numObj;
> +--------+----------+
> | numObj | count(*) |
> +--------+----------+
> | 0 | 24 |
> | 116976 | 2 |
> | 116977 | 1 |
> | 116978 | 7 |
> | 116979 | 13 |
> | 116980 | 6 |
> | 116981 | 15 |
> +--------+----------+
> 7 rows in set (0.02 sec)
>
> mysql> select numObj,if(page='piece',sum(1),sum(0)) as n1,
> -> if(page='liste',sum(1),sum(0)) as n2
select numObj, count(if(page='piece', 1, 0)) as n1,
count(if(page='liste', 1, 0)) as n2
> -> from ttywstats
> -> where login='jdalton'
> -> and page in ('liste','piece')
> -> group by numObj;
> +--------+------+------+
> | numObj | n1 | n2 |
> +--------+------+------+
> | 0 | 0 | 34 |
> | 116976 | 2 | 0 |
> | 116977 | 1 | 0 |
> | 116978 | 7 | 0 |
> | 116979 | 13 | 0 |
> | 116980 | 6 | 0 |
> | 116981 | 15 | 0 |
> +--------+------+------+
> 7 rows in set (0.02 sec)
>
>
> --
> Best regards,
> SixK
> //
> \\ // Amiga spirit will never die
> \\/
>
> mailto:[EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
