title: Update Mysql tables upon inserting into another table
body: <p>I have 2 tables, the first tables is a transactions table which has records of all transactions, and the second table is the savings table which has the total of all transactions amounts.</p>
  <pre><code>INSERT INTO `groupsavings`.`transactions` 
          (`transactions_id`, `shareholder_id`, `transactions_type`, 
          `transactions_date`, `amount`, `pool`) 
     VALUES  (NULL, '1', 'credit', '2019-01-01', '100', 'poolone');
  
  INSERT INTO `groupsavings`.`transactions` 
          (`transactions_id`, `shareholder_id`, `transactions_type`, 
          `transactions_date`, `amount`, `pool`) 
     VALUES (NULL, '1', 'credit', '2019-01-01', '50', 'poolone');
  
  
  UPDATE `groupsavings`.`saving_pool` 
      SET `pool_value` = '100' 
  WHERE `saving_pool`.`Pool_name` = 'poolone';
  
  UPDATE `groupsavings`.`saving_pool` 
      SET `pool_value` = '150' 
  WHERE `saving_pool`.`Pool_name` = 'poolone';
  </code></pre>
  <p>I want the savings table to cumulatively add to the savings table upon inserting into transactions table.</p>