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 vote223 views1 answer
Savepoint mysql script
SQL
14 votes209 views5 answers
Set password for postgres user ubuntu
SQL
17 votes233 views1 answer
Selecting name that contain certain word in sql
SQL
1 vote197 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote291 views2 answers
Install phoenix
SQL
7 votes195 views1 answer
Sql management studio display line numbers
SQL
0 vote211 views1 answer
Geopoint from json mysql function
SQL
0 vote192 views1 answer
Initcap in sql
SQL
0 vote258 views1 answer
Insert query return id mysql
SQL
0 vote220 views1 answer
Renommer base sql
SQL