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

by

In later versions of MySQL you can use the information_schema database to tell you when another table was updated:

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

This does of course mean opening a connection to the database.

An alternative option would be to “touch” a particular file whenever the MySQL table is updated:

On database updates:

  • Open your timestamp file in O_RDRW mode
  • close it again

or alternatively

  • use touch(), the PHP equivalent of the utimes() function, to change the file timestamp.

On page display:

  • use stat() to read back the file modification time.

More Related Contents:

  1. Why do I get an error from this sub query script?
  2. sql query to modify the selected value from database [closed]
  3. Can I concatenate multiple MySQL rows into one field?
  4. Remove duplicate rows in MySQL
  5. How to do the Recursive SELECT query in MySQL?
  6. MySQL, update multiple tables with one query
  7. Error Code: 2013. Lost connection to MySQL server during query
  8. MySQL Trigger after update only if row has changed
  9. MySQL “WITH” clause
  10. mysql select dynamic row values as column names, another column as value
  11. MySQL “Group By” and “Order By”
  12. MySQL DELETE FROM with subquery as condition
  13. MySQL Query to select data from last week?
  14. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  15. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  16. Is it possible to query a tree structure table in MySQL in a single query, to any depth?
  17. Simple Random Samples from a Sql database
  18. How do I use properly CASE..WHEN in MySQL
  19. Determine Rank based on Multiple Columns in MySQL
  20. Checking multiple columns for one value
  21. What is better in MYSQL count(*) or count(1)?
  22. Delete query not working in mysql
  23. How to insert data to MySQL with auto-incremented column(field)?
  24. Replace Into Query Syntax
  25. How to enable INNODB in mysql
  26. MySQL GROUP BY DateTime +/- 3 seconds
  27. Does a UNIQUE constraint automatically create an INDEX on the field(s)?
  28. MySql – How get value in previous row and value in next row? [duplicate]
  29. Updating table in trigger after update on the same table
  30. Syntax error: WITH is not valid input in this position

Leave a Comment