"Chris Boget" <chris@wild.net> writes:
>> > 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?
Defaults only apply at INSERT time, not UPDATE.
-Doug