如何得知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屋!