Deleting older records
| From: | Dylan Barber | Date: | Fri, 13 Aug 2004 05:08:56 +0000 |
| Subject: | Deleting older records | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35676@lists.php.net to get a copy of this message | ||
I have a tracking database but I only need things in it for about an hour
I tried this
DELETE * FROM
tblDownloadTrack WHERE timestamp < TIME_TO_SEC( NOW( ) )
but it gives me an error anybody help me out on this?
MySQL 4.0.16
Dylan Barber
<file:///C:/Documents%20and%20Settings/Dylan/Application%20Data/Microsoft/Si
gnatures/www.codegalaxy.com> www.codegalaxy.com - A webservices company
DotNetNuke Portal Specialists
Simple Affordable & Reliable - Web Design, and Programming