Triggers for date verification

Question

I’m having a question!

I have a schedule of contracts and wanted to update the field of data_exclusao for the current date each time the field data_inicio is possible through triggers? I’m a beginner in triggers and I know the basics...

Answer 1

You can use Event Scheduler

Scheduled tasks of this type are also sometimes known as " time triggers "

A small example can be found in documentation theirs:

CREATE EVENT [IF NOT EXIST]  event_name
ON SCHEDULE schedule
DO
event_body