Re: on update set default

"Ben-Nes Michael" <miki@canaan.co.il> writes:

> Hi All
>
> Im want that on each insert, update to a table the column:
> changed_on TIMESTAMP DEFAULT now()
> will be set to now();
>
> any one can hint me ?
> I tried few rulles and triggers for hours with no luck :(

An AFTER trigger to do this should be pretty easy.  Why don't you post
what you've tried and we'll see where you went wrong?

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863