title: how to execute a trigger everyday at once in sql
body: <p>we are doing a project on microbanking and we need to calculate the interest rate in database level. So we used procedures and triggers for that. but the trigger needs to execute everyday at once to perform below given procedure. Can you provide a solution to create that trigger. Thanks in advance</p>
  
  <pre><code>DELIMITER //
  
  create procedure addFDInterestToAccount(in account_number bigint(20))
  BEGIN
  declare interest float default 0;
  declare account_type varchar(10);
  declare rate float;
  declare savings_account bigint(20);
  
  start transaction;
  select balance from fd_account where account_no = account_number into interest;
  SELECT plan_id from fd_account where account_no = account_number into account_type;
  SELECT saving_account_no from fd_account where account_no = account_number into savings_account;
  select interest_rate from fd_plan where plan_id = account_type into rate;
  set interest = interest*rate/1200;
  
  insert into transaction (transaction_id, account_no, credit_debit, date_time, amount, type_, agent_id, is_fee)  values (null, savings_account, 'debit', now(), interest, 'not_special', null, false);
  update account set balance = balance + interest where account_no = savings_account;
  commit;
  END //
  DELIMITER ;
  
  call addFDInterestToAccount(90842311);
  </code></pre>