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

1 vote347 views1 answer
Ora-01109 database not open in oracle 19c
SQL
4 votes265 views1 answer
And or sql order of operations
SQL
0 vote320 views1 answer
Sql contains numeric characters
SQL
1 vote314 views2 answers
Sql now - 1 day
SQL
0 vote311 views1 answer
Multiple tricky query in sql server
SQL
0 vote299 views1 answer
How to connect to mysql in ef 6
SQL
0 vote315 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
1 vote315 views1 answer
Postgresql delete cascade
SQL
0 vote333 views1 answer
Renommer base sql
SQL
0 vote310 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL