Hi, i want to retreive the time that a table in my database was last updated.
I currently have the following query that returns an update_time but it appears to be wrong as when i perform an update on the data in the table the time normally remains the same.
SHOW TABLE STATUS LIKE 'tests'
Also is their anyway to restrict the values this query returns to just update_time as the rest are not required?
Then format the date returned possibly using DATE_FORMAT to another arrangement or to a unix timestamp?
PS i'm running MySQL 4.1.14
and the table type is MyISAM