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:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 4:07 PM To: [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]