One option would be to add a column to the table with a last_updated
timestamp. Everytime you update the row, update the last_updated field with
the current timestamp. Therefore you could just query the timestamp column
to get recently updated rows (or not so recently updated) as you please.
--
The only way I could think of is to have a column that's an auto updated
timestamp and then just query using that time.
`updated_on` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP
So for your mass update, I'd SET @updated_time = NOW(); and then you could
use that in
Do you have a timestamp field on this table?
There's no way of seeing when a row was last updated unless you have a
timestamp field that automatically updates for any change (that's *any*
change - not necessarily the ones you want to keep track of) or creating
your own and updating them either on
Hi,
Thank you all for your prompt response. Unfortunately timestamp file isn;t
there, so I will find some other way to do it.
Seems timestamp is a valuable field ( unless you want to save resource on
generating timestamps on a very busy table).
Thanks
(timestamp)
*http://en.wikipedia.org/wiki/Long_and_short_scales
-Original Message-
From: MadTh [mailto:madan.feedb...@gmail.com]
Sent: Monday, June 14, 2010 2:23 PM
To: mysql@lists.mysql.com
Subject: Re: list rows with no recent updates
Hi,
Thank you all for your prompt response