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

5 votes172 views1 answer
Oracle nls parameters
SQL
1 vote180 views1 answer
Default
SQL
3 votes167 views2 answers
Mysql import gz
SQL
7 votes154 views2 answers
Mysql get year from date
SQL
1 vote167 views2 answers
Mysql limit offset
SQL
9 votes152 views2 answers
Sql limit order by
SQL
4 votes146 views2 answers
How to delete row in sql
SQL
9 votes202 views3 answers
Postgres make sql dump
SQL
0 vote157 views1 answer
Sql get highest date from 3 tabels
SQL
1 vote168 views1 answer
Select 2 rows in sql
SQL