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 vote252 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote251 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
1 vote210 views1 answer
How to run sql script
SQL
0 vote259 views1 answer
Android sqlite get rows count
SQL
1 vote292 views1 answer
Primary key with prefix sql
SQL
1 vote268 views1 answer
Drop df constraint sql server
SQL
0 vote254 views1 answer
Set column width in sqlplus
SQL
9 votes275 views1 answer
Alter table column change data type to text mysql
SQL
0 vote291 views1 answer
How do I insert a blob in SQL?
SQL
0 vote252 views1 answer
The local psql command could not be located
SQL