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

Posted by RaGE on Stack Overflow See other posts from Stack Overflow or by RaGE
Published on 2008-11-21T00:48:59Z Indexed on 2010/05/25 7:21 UTC
Read the original article Hit count: 214

Filed under:
|
|

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 date ? Should I make an access to the database everytime my footer is displayed ?

© Stack Overflow or respective owner

Related posts about php

Related posts about sql