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

1 vote310 views1 answer
How to change owner in postgres
SQL
1 vote298 views1 answer
Sql server get users
SQL
5 votes334 views1 answer
Sql integer to serial
SQL
1 vote292 views1 answer
Mysql select month and year
SQL
0 vote303 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote301 views1 answer
Mariadb number format
SQL
0 vote303 views1 answer
Sql remove last 2 digit
SQL
1 vote317 views1 answer
Postgres cast as currency format
SQL
0 vote328 views1 answer
000webhost database values insert
SQL
0 vote306 views1 answer
How to combine rows in sql server procedure
SQL