mysql获取数据库表最后更新时间，update_time 为null

http://www.busfly.net/csdn/post/mysql-show-get-database-info.html

http://www.dbforums.com/mysql/1657703-update_time-innodb.html

查询语句的话是    SELECT '表名',UPDATE_TIME FROM information_schema.tables where TABLE_SCHEMA='数据库';"

或者用变量  show table status.

但是我查到的 update_time 和check_time 总是null  。information_schema的tables表也无法修改。百度，google几乎都是在自己的表中的update_time相关的。

费劲力气终于在老外网站上（第二个链接）找到了：In the MySQL "information_schema" database is a table called "TABLES" and it has a "UPDATE_TIME" column for each table in all databases on the given s MySQL server.

For MyISAM tables the "UPDATE_TIME" field is updated every time a change to the given table is made, for InnoDB tables the value for "UPDATE_TIME" is always NULL.

Maybe someone knows if there is a patch, so InnoDB tables get their "UPDATE_TIME" value updated as well.

Thanks,
David

原因在于innodb存储引擎不支持（？）update_time，所以，只要把表改成  myisam存储引擎的就 ok了。