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 vote544 views1 answer
Get first match in each group mysql query
SQL
0 vote383 views3 answers
How to find all role in mysql
SQL
0 vote335 views1 answer
Transaction database with php
SQL
3 votes315 views1 answer
Sql datetime as date
SQL
0 vote315 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
2 votes308 views2 answers
Sqlite_busy: database is locked
SQL
0 vote339 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote277 views1 answer
Now() -1 mysql
SQL
4 votes322 views3 answers
Sqlite show columns
SQL
0 vote338 views1 answer
Mysql aspas simples
SQL