Forum Moderators: phranque

Message Too Old, No Replies

cache control system - MySQL DB problem

Determining the date of the last DB update

         

semya

7:23 am on Jan 15, 2003 (gmt 0)

10+ Year Member



Good day,
not sure if this post is pertinent in this very forum, but too many of them - no time to choose...

the problem is as follows: i'm currently writing a cache control system and have to track all DB changes to respond correctly with headers information. db is mysql, script is being written in PHP. How can i get the last update time and date for a certain db?

right now i do the following: show table status from my_db_name -> find the maximum from Update_time field

but may be there's a shorter, or easier way?
thanks.

DaveAtIFG

2:25 pm on Jan 16, 2003 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Do any of you MySQL wizards have any suggestions for semya?