Make my first schedule task an action at a certain time

[Crescenzo Cuomo]

Hello everybody,
I need support to create my first mysql schedular event,
briefly explaining the situation I tell you:

I have an appointment table in the database,
my requirement is that every day at 20:00 the triggers identify all the appointments
who have given (equal to today's date) and been "IN PRODUCTION" appointment and moved to half
update all appointments the following day:

I tried to throw you down a bland attempt:


CREATE EVENT IF NOT EXISTS `update_data`
ON SCHEDULE EVERY 20 DAY_HOUR
COMMENT 'Si esegue alle 08:00PM '
DO select * from appuntamenti where `data` = CURDATE();
update appuntamenti SET `data` = CURDATE() + 1 WHERE `stato_pren` = "ATTESA ACCETTAZIONE" OR `stato_pren` = "LAVORAZIONE";


I thank all of you in advance