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
002 11:22 PM
> To: [EMAIL PROTECTED]
> Subject: Clear table contents
>
>
> Hello gurus,
>
> Please allow me to request for help with the table below.
>
>
> mysql> select * from relay_ip;
> +-+++-
>
Hello gurus,
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
| |
+--
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
>
Hello gurus,
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
| |
+--
