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 vote250 views2 answers
Postgres autoincrement primary key
SQL
0 vote260 views1 answer
Move table to a different schema
SQL
0 vote228 views1 answer
Oracle flush Shared Pool
SQL
-1 vote258 views1 answer
Brisanje dupliranih konatakata
SQL
3 votes245 views1 answer
Set default today mysql
SQL
1 vote226 views1 answer
Sample in sql
SQL
0 vote241 views1 answer
How to to get current date in sql
SQL
0 vote342 views1 answer
Sql insert exemplo
SQL
0 vote245 views1 answer
Oracle select partition
SQL
1 vote226 views1 answer
Load sql into mamp
SQL