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 vote141 views1 answer
Oracle sql number to varchar2
SQL
1 vote133 views1 answer
Create new table from old table
SQL
0 vote121 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
1 vote119 views1 answer
Launch sql script from docker in mysql
SQL
14 votes198 views1 answer
How to export db from mysql
SQL
0 vote120 views1 answer
In mysql workbench contnent not feching
SQL
3 votes130 views3 answers
Remove all spaces from string sql
SQL
0 vote126 views1 answer
Why we have to set the password for my sql server
SQL
0 vote129 views1 answer
Sql server select record with max id
SQL
57 votes302 views6 answers
Sql alter table
SQL