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.