Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 2000051

Re: [PHP3] Display when database was last updated From: php3 <email protected>
Date: 05/16/00

Addressed to: tyler.longren <email protected>
              php3 <email protected>

** Reply to note from Tyler Longren <tyler.longren <email protected>> Mon, 15 May 2000 16:25:00 -0500
>
> Hello everybody,
>
> How can I get the date when a MySQL database was last updated? This
> can't be too hard, but I don't know how to do it. Thanks!

Last update of the entire database? Yes, it might be quite hard. You
might get away with looking at the modify date of the files that contain
the database, but there is more than one file per table, so it could be
quite messy.

You could add a table with a single row, and update a TIMESTAMP or
DATETIME field in it each time you change anything else in the table.

Update time of a single record, that is easy. Just include a field of
type TIMESTAMP in the record and MySQL will update it with the current
time every time anyting else in the record is changed.

Rick Widmer
Internet Marketing Specialists
www.developersdesk.com 

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>