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.
--
A
it. Plus it's stored internally as an integer (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 ro
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
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
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 your
