我正在尝试解决以下问题：

我有两个表，第一个称为“付款”，看起来像这样：

./assets/img/abc.jpg

第二个表称为“月”，如下所示：

id_payment |  date      | id_month |  total 
-----------+------------+----------+--------
1          | 2019-01-01 |    1     |     0 
2          | 2019-01-02 |    2     |   160

现在的问题是，如果我更新其中一项付款的日期，则触发器应使表格如下所示：

id_month | month_name    | initial_date | final_date | total_payments 
---------+---------------+--------------+------------+---------------
    1    | January/2019  | 2019-01-01   | 2019-31-01 |      0
    2    | February/2019 | 2019-01-02   | 2019-28-02 |    160

但是最终结果是这样的：

id_payment | date       | id_month |  total 
-----------+------------+----------+--------
    1      | 2019-01-01 |    1     |    0 
    2      | 2019-01-01 |    1     |  160


id_month | month_name    | initial_date | final_date | total_payments 
---------+---------------+--------------+------------+---------------
   1     | January/2019  | 2019-01-01   | 2019-31-01 |   160
   2     | February/2019 | 2019-01-02   | 2019-28-02 |     0

我的触发器

id_payment |  date      | id_month |  total 
-----------+------------+----------+-------
    1      | 2019-01-01 |   1      |    0 
    2      | 2019-01-01 |   1      |  160


id_month | month_name    | initial_date | final_date | total_payments 
---------+---------------+--------------+------------+---------------
    1    | January/2019  | 2019-01-01   | 2019-31-01 |    160
    2    | February/2019 | 2019-01-02   | 2019-28-02 |    160