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 [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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/[EMAIL PROTECTED]
