Re: Deleting older records
| From: | Nadim Attari | Date: | Fri, 13 Aug 2004 06:12:53 +0000 |
| Subject: | Re: Deleting older records | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35683@lists.php.net to get a copy of this message | ||
> Okay I have a timestamp field how do I create a query to delete all
entries
> older than an hour. Timestamp field is set by now() function.
DELETE FROM tblDownloadTrack WHERE
timestamp <
TIME_TO_SEC(DATE_SUB(NOW( ), INTERVAL 1 HOUR))