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 vote138 views1 answer
Mysql server does not start mac
SQL
0 vote179 views2 answers
CREATE OR REPLACE FUNCTION
SQL
5 votes148 views1 answer
Oracle get foreign keys on table
SQL
-1 vote145 views1 answer
Get id from just inserted row mysql server python
SQL
14 votes144 views3 answers
Trim sql
SQL
-1 vote144 views1 answer
Can pandas fetch data from sql
SQL
1 vote145 views1 answer
Random name function in mysql for nvarchar
SQL
1 vote143 views10 answers
Stack overflow
SQL
0 vote154 views4 answers
Mysql replace regex
SQL
1 vote151 views2 answers
Sql server concat string and int
SQL