I need to know when a MySQL table was last updated. How do I get that information?

Hi Will

I would like to add something like “last updated the xx/xx/200x” on my page.
Can you tell me what the best way to do that is? Are there any functions that will retrieve the last updated date?

Kim from Rockville

One thought on “I need to know when a MySQL table was last updated. How do I get that information?”

  1. Hello Kim
    There is a way to gain the information in the later version of MySQL. You need to extract the information from the information_schema database.

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

Comments are closed.