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 vote216 views1 answer
Backup a table in sql
SQL
18 votes230 views6 answers
Create table mysql
SQL
0 vote221 views1 answer
Save single sql query result boolean spring boot
SQL
4 votes230 views4 answers
Date less than in sql
SQL
6 votes216 views1 answer
SQL insert all columns
SQL
1 vote231 views1 answer
Oracle sql average
SQL
0 vote282 views1 answer
ALV GRID events
SQL
0 vote232 views1 answer
Synapse sql table set pk
SQL
1 vote243 views1 answer
Quit mysql
SQL
27 votes241 views5 answers
Mysql set password for user
SQL