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 vote133 views1 answer
Learnxinyminutes sql
SQL
8 votes124 views5 answers
Alter table add column with default value
SQL
0 vote131 views1 answer
Mysql add text to existing field
SQL
10 votes92 views2 answers
Mysql select timestamp group by day
SQL
1 vote133 views2 answers
How to drop a unique constraint in sql
SQL
3 votes165 views1 answer
Query less than datetime sql
SQL
1 vote107 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote121 views1 answer
How to fetch unique records from two tables
SQL
5 votes203 views1 answer
Oracle asynchronous procedure
SQL
1 vote137 views1 answer
Postgresql update auto_increment value
SQL