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 vote365 views1 answer
Mysql previous year
SQL
2 votes327 views2 answers
Mysql get time from datetime
SQL
0 vote345 views1 answer
Database xml sql
SQL
0 vote428 views1 answer
Sqlite display data in separated columns
SQL
-2 votes336 views1 answer
Use of where in left join in mysql
SQL
0 vote326 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote375 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
6 votes368 views2 answers
Mysqldump password in file
SQL
2 votes294 views2 answers
Mysql get last character of string
SQL
-1 vote321 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL