Why don't you :
select timestampfield from mytable order timestampfield decs limit 1
Jay Lawrence wrote:
>
> Atle, your suggestion is for the last time a record was updated. I am
> interested in the entire table.
>
> The closest that I have seen thus far is:
> SHOW TABLE STATUS
> The Update
On Thu, 15 Feb 2001, Jay Lawrence wrote:
> Atle, your suggestion is for the last time a record was updated. I am
> interested in the entire table.
A temporary workaround could be select max(timestamp) from sometable.
Jan
-
Be
Atle, your suggestion is for the last time a record was updated. I am
interested in the entire table.
The closest that I have seen thus far is:
SHOW TABLE STATUS
The Update_time field is most likely what I am after.
However I was hoping to do something more like
select Update_time from