Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE `order`
- SET `order`.`status` = 'complete'
- WHERE `order`.`status` <> 'complete'
- AND TIMESTAMPDIFF('DAY', `order`.`date`, now()) < 3;
- CREATE EVENT IF NOT EXISTS `update_status_event`
- ON SCHEDULE
- EVERY 19 DAY_HOUR
- COMMENT 'Update the status every days at 19:00'
- DO
- UPDATE `order`
- SET `order`.`status` = 'complete'
- WHERE `order`.`status` <> 'complete'
- AND TIMESTAMPDIFF('DAY', `order`.`date`, now()) < 3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement