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 vote164 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
1 vote144 views1 answer
Retrieve meaning
SQL
32 votes142 views6 answers
How to change column name in sql
SQL
0 vote134 views1 answer
Sql row number in result set
SQL
0 vote139 views1 answer
Take sql dump in to file
SQL
5 votes144 views1 answer
Mysql count newlines in field
SQL
5 votes144 views4 answers
Change auto increment mysql
SQL
0 vote129 views1 answer
What is ssrs and ssis in sql server
SQL
4 votes129 views2 answers
Dbms_scheduler stop job
SQL
1 vote139 views1 answer
Raise application error in oracle
SQL