Answers for "create events"

Whatever

0

create events

SET GLOBAL event_scheduler=ON;

CREATE EVENT update_status_event
    ON SCHEDULE
      EVERY 1 DAY
ON COMPLETION NOT PRESERVE ENABLE
    COMMENT 'Suspend Phone Service If Remaining Days < 0'
    DO
       UPDATE phone_services p, user_settings SET p.phone_service_status = 2 WHERE p.phone_service_device <> 'GP' AND p.remaining_days <= 0;

Posted by: Guest on June-04-2021

Source

Code answers related to "create events"

Code answers related to "Whatever"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#