Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Gen-ik
DevNet Resident
Posts: 1059 Joined: Mon Aug 12, 2002 7:08 pm
Location: London. UK.
Post
by Gen-ik » Wed Sep 18, 2002 8:26 am
Is it possible to check when a 'field' in a 'row' was last updated?
Short 'n sweet!
The only way I can think of doing this is to set the time in a field.. and then check against this.. but I'm sure there must be an easier way!
Thanks.
Johnm
Forum Contributor
Posts: 344 Joined: Mon May 13, 2002 12:05 pm
Location: Michigan, USA
Contact:
Post
by Johnm » Wed Sep 18, 2002 8:39 am
The only way I can think of doing this is to set the time in a field.. and then check against this.. but I'm sure there must be an easier way
That sounds like a pretty easy way in itself.
Direwolf
llimllib
Moderator
Posts: 466 Joined: Mon Jul 01, 2002 2:19 pm
Location: Baltimore, MD
Post
by llimllib » Wed Sep 18, 2002 12:32 pm
look at it from the mysql developer's side: Imagine they had put a timestamp on every database change. How much memory/time would that have taken? would it have been worth it to save somebody a couple seconds and some planning? Sorry, you gotta do it yourself. It builds character, as my dad would say