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 vote131 views1 answer
Sql table to store status
SQL
25 votes199 views5 answers
Mysql replace text
SQL
4 votes193 views1 answer
Postgresql create table with index
SQL
0 vote150 views2 answers
How to update date in oracle
SQL
0 vote249 views1 answer
Print hello world in plsql
SQL
2 votes169 views1 answer
Sql string_agg
SQL
0 vote153 views1 answer
What is the use of index in mysql table
SQL
0 vote142 views1 answer
Create table employees oracle
SQL
0 vote192 views1 answer
Sql server rtrim everything after character
SQL
2 votes143 views1 answer
Can you use a where clause for a child query
SQL