mysql> show table status like '<tablename>'\G
will report you the date and time of creation, updation,etc of the specified table. 'SHOW
STATUS' enables only view.
Note 1: For some storage engines, this value is NULL. For example, InnoDB stores multiple
tables in its tablespace and the data file timestamp does not apply.
As you have specified that you want it to display it in the webpage, then retrieve the
same from the 'tables' table of information_schema database.
mysql> use information_schema;
mysql> show tables;
mysql> select * from TABLES where TABLE_NAME='<tablename>';
Note 2: Check the user privilege to access the database. If not grant it.
ViSolve DB Team.
----- Original Message -----
From: "Marcelo Fabiani" <marcelofabiani@stripped>
Sent: Friday, December 22, 2006 6:21 AM
Subject: find date an time of a table update
> Hi, I didn't find a way to know the time and date of the last update of
> table, not the data but the table info itself.
> Is this possible?
> I want to use this info in order to show it in a web page.
> Mysql 4.1
> Marcelo Fabiani
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1