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 vote120 views1 answer
Sql server kill all connections
SQL
1 vote120 views1 answer
How to select rows with no matching entry in another table?
SQL
1 vote129 views1 answer
Quit mysql
SQL
3 votes110 views2 answers
Oracle sql drop sequence
SQL
0 vote121 views3 answers
Database restoring error
SQL
0 vote122 views2 answers
Mysql select date from datetime
SQL
0 vote137 views2 answers
Sql auto update dupdated_at
SQL
1 vote128 views1 answer
Age postgres
SQL
0 vote118 views1 answer
Get current date data in mysql
SQL
0 vote126 views1 answer
How to combine rows in sql server procedure
SQL