Printing date and time when MySQL database was last updated

How do I print the date and the time when a MySQL database was last updated? I need to do this to see how often teachers at my school update their webpages through a control pannel. Thanks!

Tyler Longren

Hi,

just create a "last_updated" column in your table.This column should be
updated with the current date when ever the teacher's try to update the control panel.

or

probably you can create a separate table with teachers_id and last_updated fields.
then update this table when ever teachers try to update some thing.




------------------
SR -
shiju.dreamcenter.net

"I will love thee, O Lord,my strength"