Mysql procedure between two tables

1. SET GLOBAL event_scheduler=ON
2. 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 u SET p.phone_service_status = 2, u.is_app_enabled=0, u.device_identifier='' WHERE p.phone_service_device <> 'GP' AND p.remaining_days <= 0;

Similar codes

2 votes190 views1 answer
Match in sql server
SQL
0 vote226 views1 answer
Adding generated time in row mysql workbench
SQL
3 votes173 views2 answers
Mysql sum with condition
SQL
0 vote235 views1 answer
Postgresql port 5432 not open
SQL
0 vote254 views1 answer
Get last inserted primary key
SQL
0 vote239 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote216 views1 answer
Window function to forward fill
SQL
0 vote233 views1 answer
Sql sum if
SQL
27 votes271 views3 answers
Mysql delete row
SQL
0 vote236 views1 answer
Compare field sql server
SQL