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 votes182 views1 answer
Mysql check date range
SQL
0 vote200 views1 answer
Oracle winter time change
SQL
0 vote188 views1 answer
Openquery update linked server
SQL
2 votes185 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes183 views1 answer
Removing view
SQL
0 vote191 views2 answers
Import .sql into postgres db command
SQL
-1 vote184 views5 answers
Operator in sql
SQL
0 vote198 views1 answer
Ansi sql count duplicate rows
SQL
7 votes169 views1 answer
Mysql unsafe update
SQL
1 vote182 views3 answers
Mysql connection string
SQL