Hello,
does anyone know how to get table "update_time" using innodb engine?

Thanks,
David

I think you just need to query the information_schema.tables
MySQL :: MySQL 5.0 Reference Manual :: 19.2 The INFORMATION_SCHEMA TABLES Table

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

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.

Thanks,
David