How can I tell when a MySQL table was last updated ?

In later versions of MySQL you can use the information_schema database to tell you when another table was updated:

---------------------------------------------------------------------------------------------------------------------------

SELECT UPDATE_TIME
FROM   information_schema.tables
WHERE  TABLE_SCHEMA = 'dbname'
AND TABLE_NAME = 'tabname'

--------------------------------------------------------------------------------------------------------------------------

#erdurgeshsingh

Post a Comment

0 Comments