Re: After update trigger on same table

[Peter Brawley]

> whenever a specific column('Num_cons_logins')gets updated I need to update another column of the same table

You can change column values in the row referenced in the trigger ...

if new.nums_cons_logins <> old.nums_cons_logins then
  set new.othercolname=othervalue;
end if;
[/end if;

You can't update other rows in the same table (because that would incite an infinite loop).

PB