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 vote141 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote115 views1 answer
Django mssql backend
SQL
7 votes144 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
6 votes125 views3 answers
Sql select last id
SQL
0 vote123 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote160 views1 answer
Oracle sql all days except weekends
SQL
0 vote136 views1 answer
Sql insert query list of dictionaries
SQL
0 vote124 views1 answer
Creating a simple notify in postgresql
SQL
0 vote72 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote121 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL