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. I can do this in Oracle but it escapes me in MySQL 4.0.16 Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal Specialists Simple Affordable & Reliable - Web Design, and Programming > -----Original Message----- > From: Dylan Barber [mailto:dylan.barber@xxxxxxxxxxxxx] > Sent: Friday, August 13, 2004 12:17 AM > To: 'Ng Hwee Hwee'; php-db@xxxxxxxxxxxxx > Subject: RE: Deleting older records > > 1064 - You have an error in your SQL syntax. Check the > manual that corresponds to your MySQL server version for the > right syntax to use near '* FROM `tblDownloadTrack` WHERE > `timestamp` < TIME_TO_SEC( > > > Dylan Barber > > www.codegalaxy.com - A webservices company > > DotNetNuke Portal Specialists > > Simple Affordable & Reliable - Web Design, and Programming > > > > > -----Original Message----- > > From: Ng Hwee Hwee [mailto:hhwee@xxxxxxxxxxx] > > Sent: Friday, August 13, 2004 12:15 AM > > To: php-db@xxxxxxxxxxxxx > > Subject: Re: Deleting older records > > > > what was the error?? > > > > ----- Original Message ----- > > From: "Dylan Barber" <dylan.barber@xxxxxxxxxxxxx> > > To: <php-db@xxxxxxxxxxxxx> > > Sent: Friday, August 13, 2004 1:08 PM > > Subject: Deleting older records > > > > > > > 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%20Dat > > a/Microsoft/Si > > > gnatures/www.codegalaxy.com> www.codegalaxy.com - A > > webservices company > > > > > > DotNetNuke Portal Specialists > > > > > > Simple Affordable & Reliable - Web Design, and Programming > > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) To > unsubscribe, visit: > > http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) To > unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
