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 vote266 views1 answer
T sql cursor tr
SQL
0 vote273 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
0 vote254 views1 answer
Mysql select where field is a value
SQL
0 vote248 views1 answer
Sql remove non numeric characters
SQL
0 vote264 views1 answer
Start stop mysql linux
SQL
4 votes248 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote253 views1 answer
Find number of entries sql
SQL
0 vote201 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote262 views1 answer
Tsql pad left
SQL
27 votes269 views5 answers
Add column in table
SQL