re: Timestamp and deleteing records.

2003-03-06 Thread Victoria Reznichenko
On Thursday 06 March 2003 13:40, wrote: > I'm currently building a database and am using a timestamp(14) column for > keeping track of when an entry was added to it. Is there an easy way to > remove records that are more than 180 days old inside a MySQL query > instead of going through and removi

Re: Timestamp and deleteing records.

2003-03-06 Thread Roger Baklund
* [EMAIL PROTECTED] > I'm currently building a database and am using a timestamp(14) column for > keeping track of when an entry was added to it. Beware that this column also will be updated when you update _any_ column in the row... http://www.mysql.com/doc/en/DATETIME.html > > Is there an easy

Timestamp and deleteing records.

2003-03-06 Thread ed
I'm currently building a database and am using a timestamp(14) column for keeping track of when an entry was added to it. Is there an easy way to remove records that are more than 180 days old inside a MySQL query instead of going through and removing tham all by hand, Thanks, Ed