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 vote388 views1 answer
Select place default lat long
SQL
0 vote362 views1 answer
T sql check active deadlock
SQL
2 votes400 views2 answers
Mysql does sentence contain word
SQL
7 votes369 views3 answers
How ot change name of column mysql
SQL
4 votes373 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote371 views1 answer
Mysql page segment
SQL
0 vote375 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
2 votes363 views1 answer
Change primary key sql
SQL
0 vote383 views1 answer
Adding primery key constraint to a column
SQL
0 vote353 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL