Monday, May 8, 2017

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 ... thumbnail 1 summary
  • You can try this code:  CREATE EVENT event_add_interest ON SCHEDULE EVERY 1 MONTH STARTS LAST_DAY ( CURDATE ()) DO INSERT INTO ...