mysql查询最后更新时间,如何得知MySQL表的最后更新时间？

In the footer of my page, I would like to add something like "last updated the xx/xx/200x" with this date being the last time a certain mySQL table has been updated.

What is the best way to do that? Is there a function to retrieve the last updated date? Should I access to the database every time I need this value?

解决方案

In later versions of MySQL you can use the information_schema database to tell you when another table was updated:

SELECT UPDATE_TIME

FROM information_schema.tables

WHERE TABLE_SCHEMA = 'dbname'

AND TABLE_NAME = 'tabname'

This does of course mean opening a connection to the database.

An alternative option would be to "touch" a particular file whenever the MySQL table is updated:

On database updates:

Open your timestamp file in O_RDRW mode

close it again

or alternatively

use touch(), the PHP equivalent of the utimes() function, to change the file timestamp.

On page display:

use stat() to read back the file modification time.