Thread: TimeStamp for insert/update

TimeStamp for insert/update

From
Zsolt Varga
Date:
hi!

I don't know is it possible or not, to make
a filed in any table which contains the insertion/update time
I know
CREATE TABLE ( instime timestamp default now(),.... );
works well for inserts..
but can I do the same for update?

thanks
    redax

ps; or it's a 'rules' question?
--
.----------------------------------------------------------.
|Zsolt Varga            | tel/fax:   +36 36 422811         |
| AgriaComputer LTD     | email:     redax@agria.hu        |
| System Administrator  | URL:       http://www.agria.hu/  |
`----------------------------------------------------------'