Re: Mysql Question
| From: | Richard Lynch | Date: | Sun, 04 Feb 2001 03:27:59 +0000 |
| Subject: | Re: Mysql Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-38062@lists.php.net to get a copy of this message | ||
>Can i know the date of the last table update in a Mysql database?
You can add a field named 'modified' that is of type 'timestamp' and use:
select max(modified) from blah;
I don't know of any documented way to check the last modified time for a
whole table.
--
Visit the Zend Store at http://www.zend.com/store/
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer a little time: http://chatmusic.com/volunteer.htm