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'
FROM information_schema.tables
WHERE TABLE_SCHEMA = 'dbname'
AND TABLE_NAME = 'tabname'
--------------------------------------------------------------------------------------------------------------------------
#erdurgeshsingh
0 Comments