Should not be too difficult to answer for somebody who already did it once. I want to create a trigger on a particular field (let's say field1) on a table (let's say table1). Field1 is in column 8 of table1. To be more precise each time this fiel is updated, I need to write down the system date on another field (let's say field2) in the SAME row that has been updated. The field2 (datetime field) is in column 12 of Table1.
Can any body get me a CREATE TRIGGER statement to do the job OR suggest me of another maybe smarter way.