"Jason Frisvold" <[EMAIL PROTECTED]> wrote:
> Is there any way to query a mySQL database for the last time it was
updated?
> I need this ability to trigger a "restart" in some other applications that
> create config files and such for MRTG...
Create a field with type DATETIME and update it when a record is updated or
inserted. Then use SELECT MAX(datetime_field_name) and trigger your action
based on your criteria. If you are running MySQL with logging you may be
able to get update time info. from there as well.
--
Steve Werby
President, Befriend Internet Services LLC
http://www.befriend.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
