When a MySQL table was last updated?

Simply do this:

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

nJoy ;-)

Leave a Reply

Your email address will not be published. Required fields are marked *