Click to See Complete Forum and Search --> : [RESOLVED] Trigger AFTER UPDATE column


kerepuki
12-23-2009, 09:03 PM
Hi,

I am trying to create a trigger which only fires after a field has been updated, not row.

Example:
I have a user table with last login value. I also have a field for last modified value. I want to create a trigger (or 2) which writes to a log table the values if a user has logged in or if a user has edited their details.

Thanks

yamaharuss
12-26-2009, 04:58 PM
So share your resolve please.