Re: New to triggers-- help on field change

[Peter Brawley]

Something like ...

Create Trigger After Update On User For Each Row
Insert Into BalanceHistory 
Set
  User_idUser_FK=OLD.user,
  timestamp=Now(),
  change_amount=NEW.cur_balance-OLD.cur_balance,
  old_balance=OLD.cur_balance,
  new_balance=NEW.balance;

but change_amount is entirely redundant, lose it.