Dynamic insertion according to date and days of the week

Question

I’m creating an application using webservice in PHP. Within the application the user will set specific days to generate an alert, for example:

• second
• fourth
• sixth

In this way, I would like my bank to register an entire event, Monday, Wednesday and Friday successively every week, and show in Timeline user. I don’t know if I have to do triggers(do not know if it is possible) in the database or a service in PHP. Someone can clarify me a little?!

Answer 1

You can create a Event Scheduler in the database. First enable the resource:

SET GLOBAL event_scheduler = ON;

or

SET GLOBAL event_scheduler = 1;

Then create the event. In the following case the event runs daily and inserts a record in the table ALERTA:

CREATE EVENT novoEvento
ON SCHEDULE EVERY 1 DAY
DO
INSERT INTO alerta(descricao) values('ALERTA');

To show all events:

SHOW EVENTS;

---

23.4 Using the Event Scheduler

The Mysql Event Scheduler manages the Scheduling and Execution of Events, that is, tasks that run According to a Schedule.

In free translation:

Mysql Event Scheduler manages the scheduling and execution of events, which are, tasks that run according to scheduling.