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

0 vote152 views1 answer
Power query datetime to date
SQL
0 vote157 views1 answer
Sql cnvert bit to nvarchar
SQL
1 vote144 views1 answer
Mysql select row max date
SQL
4 votes251 views6 answers
Laravel jwt
SQL
0 vote152 views2 answers
Starting mysql service from mac
SQL
12 votes146 views1 answer
Docker mysql random root password
SQL
4 votes170 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote143 views1 answer
How to declare variable date in mysql
SQL
0 vote155 views1 answer
Sql express database size limit
SQL
0 vote154 views1 answer
Select top 3 sql
SQL