- Original Message -
From: "Dan Nelson" <[EMAIL PROTECTED]>
To: "Aaron Clausen" <[EMAIL PROTECTED]>
Cc: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, June 16, 2004 10:20
Subject: Re: Tough Query Problem
> In the last episo
In the last episode (Jun 16), Aaron Clausen said:
> I am trying to write a script that can take logs from our mail
> server, boil down the rejections to determine the sources of
> distributed SMTP dictionary attacks against our mail server.
>
> Basically I have a table "send_failures like this tha
I am trying to write a script that can take logs from our mail server, boil down the
rejections to determine the sources of distributed SMTP dictionary attacks against our
mail server.
Basically I have a table "send_failures like this that gets fed with the raw data from
the logs:
host_ip
hi
I need to select the ten latest entries from a diary-database, but i don't want
to get any duplicate users, so if i want to select the ten latest entries and
someone has written five entries of these latest ones, i only want to get the
latest entries from each user. So far no problem, my query