var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: "update_time" for innodb
does anyone know how to get table "update_time" using innodb engine?
I'm 99.9% sure that valule doesn't exist in Innodb.
i think the original poster was asking about retrieving a timestamp for when the last update was made to the table
Originally Posted by scottb
george answered it as though it was a question about whether "update_time" was a column in the table
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.