SELECT UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘dbname’ AND TABLE_NAME = ‘tabname’
资料来源:如何得知MySQL表的最后更新时间?
如何获得MySQL数据库的最后访问时间(和/或写入时间)?
SELECT UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘dbname’ AND TABLE_NAME = ‘tabname’
资料来源:如何得知MySQL表的最后更新时间?