Re: duplicate entry (same time every day)

2006-03-09 Thread Ronan McGlue
[EMAIL PROTECTED] wrote: Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM: > i have a little quirck with my current Mysql setup. I log all messages > from my mtas into Mysql and then use a simple query to generate stats > from them... as below: > > mysql> select exim.hour,

Re: duplicate entry (same time every day)

2006-03-09 Thread SGreen
Ronan McGlue <[EMAIL PROTECTED]> wrote on 03/09/2006 05:05:15 AM: > i have a little quirck with my current Mysql setup. I log all messages > from my mtas into Mysql and then use a simple query to generate stats > from them... as below: > > mysql> select exim.hour,sum(exim.count),stats.spam,stat

duplicate entry (same time every day)

2006-03-09 Thread Ronan McGlue
i have a little quirck with my current Mysql setup. I log all messages from my mtas into Mysql and then use a simple query to generate stats from them... as below: mysql> select exim.hour,sum(exim.count),stats.spam,stats.ham from servers,exim,stats where exim.date=stats.day and exim.date =curd