I create a test procedure.

CREATE PROCEDURE Daily_Insertion1() BEGIN insert into deliverability.test_month (type,from_sale) select type,from_sale from deliverability.delivery_money_repo where total = 289001; END

And the event

 CREATE EVENT myevent1 ON SCHEDULE EVERY 1 DAY STARTS '2017-02-22 11:14:00' DO CALL Daily_Insertion1

Installed soon to test performance. Didn't work, what did you do wrong?

  • How did you determine that "did not work"? I think the event is completed, the procedure is running, but in the process of execution, either an error or an empty record set, therefore, nothing fell into the target table. - Akina
  • @Akina The request itself, without a procedure, correctly inserts data. At the specified time, nothing was added to the table, after the intended action of the procedure / event. - cruim
  • Check then according to the log whether the event was launched or not. Well, just in case, check whether the event sheduler is running at all ... - Akina

0