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

In the footer of my page, I would like to add something like “last updated the xx/xx/200x” with this date being the last time a certain mySQL table has been updated.

What is the best way to do that? Is there a function to retrieve the last updated date? Should I access to the database every time I need this value?

17 Answers
17

Leave a Comment