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 vote144 views2 answers
Datetrunc hour snowflake
SQL
0 vote141 views1 answer
Search starting with mysql
SQL
1 vote130 views1 answer
Mysql get character set
SQL
0 vote143 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote138 views1 answer
STOP message of how many rows affected sql
SQL
1 vote125 views1 answer
Set statistics on in ssms
SQL
1 vote153 views2 answers
Sql now - 1 day
SQL
0 vote151 views1 answer
Mysql backup query
SQL
0 vote147 views1 answer
How to map sql column to custom names
SQL
2 votes149 views1 answer
Sql string_agg
SQL