RE: [PHP-DB] MySQL Last Modified
| From: | Rick Emery | Date: | Wed, 24 Oct 2001 21:09:50 +0000 |
| Subject: | RE: [PHP-DB] MySQL Last Modified | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13691@lists.php.net to get a copy of this message | ||
MySQL command: show table status
This command returns multiple fields, including date/time of last update,
for each table in the selected database.
Call it with mysql_query("show table status")
Check the MySQL manual for more information
-----Original Message-----
From: Sheridan Saint-Michel [mailto:webmaster@foxjet.com]
Sent: Wednesday, October 24, 2001 4:07 PM
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL Last Modified
Is there any way to tell when a TABLE in MySQL was last modified?
I don't want to add a timestamp field as there are thousands of rows,
and I just need to know when ANYTHING in the table was last modified.
I haven't been able to find anything on this, and thought I would ask before
kludging together a workaround =P
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com