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 vote191 views1 answer
Database traccar
SQL
2 votes188 views2 answers
Created at and updated at in mysql
SQL
1 vote188 views1 answer
Oracle difference between two dates in years
SQL
0 vote175 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote251 views1 answer
Cartesian product sql
SQL
0 vote227 views4 answers
Rownum in sql
SQL
-1 vote196 views2 answers
Mysql get day of week
SQL
0 vote186 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
8 votes200 views1 answer
Oracle all_source package body
SQL
11 votes189 views2 answers
Mysql set safe mode off
SQL