List:General Discussion« Previous MessageNext Message »
From:ViSolve DB Team Date:December 22 2006 5:59am
Subject:Re: find date an time of a table update
View as plain text  
Hi,

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.

Thanks
ViSolve DB Team.


----- Original Message ----- 
From: "Marcelo Fabiani" <marcelofabiani@stripped>
To: <mysql@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
> Apache
> Myisam
> 
> Regards
> 
> Marcelo Fabiani
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
Thread
find date an time of a table updateMarcelo Fabiani22 Dec
  • Re: find date an time of a table updateViSolve DB Team22 Dec