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

1 vote110 views1 answer
Name of today sql
SQL
0 vote110 views1 answer
Sqlplus change user
SQL
2 votes120 views1 answer
Removing view
SQL
0 vote109 views1 answer
Import sql in postgresql
SQL
0 vote110 views1 answer
Apt install sql server
SQL
0 vote97 views3 answers
Remove folders from remote git
SQL
0 vote105 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote133 views1 answer
Alter domain sql
SQL
0 vote102 views1 answer
Restart sql server command line linux
SQL
1 vote496 views1 answer
How to lock table in mysql
SQL