Should not reply to such non-existing guy/email ... But how can one know
before he/she puts time in?
-------- Original Message --------
Subject: Returned mail: see transcript for details
Date: Fri, 27 Jul 2001 14:43:29 -0500 (CDT)
From: Mail Delivery Subsystem <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
The original message was received at Fri, 27 Jul 2001 14:42:37 -0500
(CDT)
from mastersvr.rjka.com [192.9.201.2]
----- The following addresses had permanent fatal errors -----
<[EMAIL PROTECTED]>
(reason: 550 <[EMAIL PROTECTED]>... User unknown)
----- Transcript of session follows -----
... while talking to mail.myhost.com.:
>>> RCPT To:<[EMAIL PROTECTED]>
<<< 550 <[EMAIL PROTECTED]>... User unknown
550 5.1.1 <[EMAIL PROTECTED]>... User unknown
Reporting-MTA: dns; rjka.com
Received-From-MTA: DNS; mastersvr.rjka.com
Arrival-Date: Fri, 27 Jul 2001 14:42:37 -0500 (CDT)
Final-Recipient: RFC822; [EMAIL PROTECTED]
Action: failed
Status: 5.1.1
Remote-MTA: DNS; mail.myhost.com
Diagnostic-Code: SMTP; 550 <[EMAIL PROTECTED]>... User unknown
Last-Attempt-Date: Fri, 27 Jul 2001 14:43:29 -0500 (CDT)
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
