Automatically insert row in mysql every month

Automatically insert row in mysql every month

You can try this code:  CREATE EVENT event_add_interest ON SCHEDULE EVERY 1 MONTH STARTS LAST_DAY ( CURDATE ()) DO INSERT INTO ... 12:05 AM

You can try this code: 

CREATE EVENT event_add_interest
ON SCHEDULE EVERY 1 MONTH STARTS LAST_DAY(CURDATE())
DO
  INSERT INTO transaction
  SELECT id, balance 
    FROM clientInfo;

 Use SET GLOBAL event_scheduler = ON;to enable the scheduler if it's currently not enabled. More on configuring event scheduler here