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']