如何使用TRIGGER在MYSQL中自动更新表 [英] How to update table automatically in MYSQL using TRIGGER

问题描述

我在mysql数据库中有一张表，用于根据利息+借入的金额来计算新欠平衡...我希望是当利息更改时，我正在使用触发器来更改新欠余额，但是它确实

I have a table in mysql database where I am calculating New Owed Balcance based on the interest + amount borrowed... I want it to be that when the interest is altered the new owed balace changes I am using Triggers but it does not seem to update it when the interest changes

DELIMITER |

CREATE TRIGGER updateloan BEFORE INSERT ON loan
  FOR EACH ROW BEGIN
    SET NEW.app_amnt_owed = NEW.app_intrst +NEW. app_ln_amnt;
  END;
|

推荐答案

CREATE TRIGGER updateloan_update
  BEFORE UPDATE ON loan
  FOR EACH ROW
  SET NEW.app_amnt_owed = NEW.app_intrst + NEW.app_ln_amnt;

这篇关于如何使用TRIGGER在MYSQL中自动更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！