MySQL time-out

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Gen-ik
DevNet Resident
Posts: 1059
Joined: Mon Aug 12, 2002 7:08 pm
Location: London. UK.

MySQL time-out

Post by Gen-ik »

Is it possible to check when a 'field' in a 'row' was last updated?

Short 'n sweet! :D


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.
User avatar
Johnm
Forum Contributor
Posts: 344
Joined: Mon May 13, 2002 12:05 pm
Location: Michigan, USA
Contact:

Post by Johnm »

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
User avatar
llimllib
Moderator
Posts: 466
Joined: Mon Jul 01, 2002 2:19 pm
Location: Baltimore, MD

Post by llimllib »

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 :)
Post Reply