Re: Touch row ?

On Friday 23 January 2004 15:52, Chris Boget wrote:
> > > is it possible to add column to database, that will automatically
> > > contain  date+time (or likely Unix timestamp) when the row was
> > > touched/changed - ie by INSERT or UPDATE ?
> >
> > Yes, a very simple trigger can do this.
>
> Wouldn't just setting the default value of the field to be NOW() accomplish
> the same thing?  Or can you not default the value of a timestamp field?

That will work for insert, but won't change when you update.

--
  Richard Huxton
  Archonet Ltd