MySQL Forums
Forum List  »  Events (Job Scheduler)

Make my first schedule task an action at a certain time
Posted by: Crescenzo Cuomo
Date: June 26, 2019 03:29AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Make my first schedule task an action at a certain time
150
June 26, 2019 03:29AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.