Re: Help with a trigger to change field to a negative value

[Peter Brawley]

Is this what you mean?

drop trigger if exists transactions_ins;
delimiter go
create trigger transactions_ins before insert on transactions for each row
begin
  if new.withdraw='yes' and new.amount > 0 then
    set new.amount = -new.amount;
  end if;
end;
go
delimiter ;