Oct
06
How to check when a MySQL table was last updated
Great little article if you are interested in finding out when the last time a table in your mySQL database has been updated. This is ideal if you have forgotten to place an updated by or last updated column in your table.
Article Blurb
I recently had to update a MySQL schema and import new data into the table. But before I could do that I needed to check that no one had updated the table during the last 7 days and no new data had been stored. As the table itself did not have any update field of itself the only other option was to look into the MySQL ‘information_schema’ database.
Tags: MySQL
