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