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
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

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to