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 vote200 views1 answer
Sql server insert inner join
SQL
0 vote164 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
5 votes162 views1 answer
Postgres integer to serial
SQL
0 vote208 views1 answer
Basic structure of sql expression having clause
SQL
0 vote181 views3 answers
Duplicate row mysql
SQL
0 vote266 views1 answer
Sql if clause within where clause
SQL
2 votes178 views1 answer
Sql finding longest and shortest names in a fleld
SQL
6 votes179 views1 answer
Oracle rank
SQL
0 vote184 views1 answer
Mysql update set sum
SQL
2 votes170 views1 answer
Plsql left() function
SQL