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
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_TIMESTAMP(NOW
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
To:
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