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_time
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
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
-
Hey all,
Is there a way to quickly obtain the last time a table was updated/touched?
In my app I am caching queries so long as the table data has not changed. I'd like a
quick check to see if a table has changed since the query was first executed. My
perusal of documentation plus a few
You might be able to use this, depending on your needs:
from http://www.mysql.com/doc/D/A/DATETIME.html
[snip]
Automatic updating of the first TIMESTAMP column occurs under any of the
following conditions:
The column is not specified explicitly in an INSERT or LOAD DATA INFILE
statement.
The