[H-GEN] Mysql query row statistics
Stephen Thorne
stephen.thorne at gmail.com
Mon Aug 29 23:45:36 EDT 2005
On 23/08/05, Anthony Irwin <irwa82 at yahoo.com> wrote:
> [ Humbug *General* list - semi-serious discussions about Humbug and ]
> [ Unix-related topics. Posts from non-subscribed addresses will vanish. ]
>
> Hi Everyone,
>
> I am looking at modifing an open source crm program
> that has a mysql database. I am adding records then
> looking at the database to see what tables have been
> effected to get a better understanding of how the
> database stores the data.
>
> I noticed that in phpmyadmin there is a row statistics
> section that lists the last update of that table. I
> was wondering if there was a way to query the database
> on that last update of the tables for the entire
> database so I can quickly see what tables are modified
> when I do things in the program.
I think what you're looking for is the query "show table status";
http://dev.mysql.com/doc/mysql/en/show-table-status.html
--
Stephen Thorne
Development Engineer
More information about the General
mailing list