something easier:
DELETE FROM relay_ip WHERE NOW() - rei_ts > 1000;
-Original Message-
From: Rick Emery
Sent: Tuesday, February 12, 2002 3:03 PM
To: 'Odhiambo Washington'; [EMAIL PROTECTED]
Subject: RE: Clear table contents
try:
DELETE FROM relay_ip WHERE UNIX_
try:
DELETE FROM relay_ip WHERE UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(rei_ts)
>600;
-Original Message-
From: Odhiambo Washington [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 11, 2002 1:22 AM
To: [EMAIL PROTECTED]
Subject: Clear table contents
Hello gurus,
Please allow me to requ
Odhiambo,
Give this a try,
DELETE from relay_ip where UNIX_TIMESTAMP(rei_ts) <
(UNIX_TIMESTAMP(NOW()) - (10 * 60));
Eric Mayers
Software Engineer
Captus Networks
> -Original Message-
> From: Odhiambo Washington [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, February 10, 2002 11:22 PM
> T
Hello Odhiambo,
> Please allow me to request for help with the table below.
> mysql> select * from relay_ip;
>
>+-+++-+-+
> | rei_aid | rei_uname | rei_domain | rei_ip | rei_ts
>
