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 vote184 views1 answer
Select amount weeks between two dates mysql
SQL
0 vote170 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote178 views1 answer
Python mysql executemany
SQL
51 votes241 views6 answers
Change column name sql
SQL
1 vote175 views1 answer
Insert column after column mysql
SQL
6 votes175 views2 answers
Mysql first day of month
SQL
0 vote160 views1 answer
Group_concat only returns one row
SQL
0 vote160 views1 answer
Inser into example
SQL
1 vote170 views1 answer
Change table to innodb mysql
SQL
0 vote173 views1 answer
Postgresql function ROUND
SQL