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 vote301 views1 answer
Mysql subtract month from timestamp
SQL
0 vote302 views1 answer
Alter rename command in mysql
SQL
0 vote285 views1 answer
Safe mysql
SQL
0 vote307 views2 answers
Mysql on update current_timestamp
SQL
0 vote304 views1 answer
List all permissions on a table in postgres
SQL
2 votes287 views2 answers
Checking data type in sql server
SQL
1 vote289 views1 answer
Mysql get character set
SQL
0 vote270 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
9 votes295 views5 answers
Sql limit
SQL
0 vote311 views1 answer
Sql server user permissions and roles
SQL