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

9 votes230 views4 answers
Oracle get table column names
SQL
0 vote180 views2 answers
Show slave status mysql
SQL
0 vote176 views1 answer
Partitioning in oracle-base
SQL
8 votes187 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote177 views1 answer
Date diff sql
SQL
0 vote208 views1 answer
Mysql dump with table query
SQL
1 vote193 views1 answer
Decalre temp table sql
SQL
0 vote201 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote182 views1 answer
How to find username and password in oracle 18c
SQL
0 vote236 views1 answer
Delete from table where length sql
SQL