Show tables ordered by modification time.

Hi,

Is it possible to show list of tables ordered by "last modification
time" and without any additional information (I need only table name
and modification time)?

Thank you.

Kurda Yon wrote:
> Hi,
>
> Is it possible to show list of tables ordered by "last modification
> time" and without any additional information (I need only table name
> and modification time)?
>
> Thank you.


See:
http://dev.mysql.com/doc/refman/5.0/...les-table.html

SELECT table_name, UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES
[WHERE table_schema = 'db_name']
[WHERE|AND table_name LIKE 'wild']

Kurda Yon wrote:
> Hi,
>
> Is it possible to show list of tables ordered by "last modification
> time" and without any additional information (I need only table name
> and modification time)?
>
> Thank you.


Forgot - if you have multiple schemas (databases) you will need that as
well.