如何得知MySQL表的最后更新时间? [英] How can I tell when a MySQL table was last updated?

问题描述

在页面的页脚中，我想添加诸如最后更新xx/xx/200x"之类的内容，该日期为最后一次更新某些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?

推荐答案

在更高版本的MySQL中，您可以使用information_schema数据库来告诉您何时更新了另一个表:

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.

另一种选择是每当更新MySQL表时触摸"特定文件:

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

关于数据库更新:

• 以O_RDRW模式打开时间戳文件
• close再次

• Open your timestamp file in O_RDRW mode
• close it again

或者

• 使用 touch() (与函数，以更改文件时间戳.

页面显示:

• 使用stat()读取文件修改时间.

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

这篇关于如何得知MySQL表的最后更新时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！