Deleting older records

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 

 

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux