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 vote359 views1 answer
Amount of entries in a table psql
SQL
0 vote378 views1 answer
Fetching data from mysqldb
SQL
2 votes360 views2 answers
Spring where to put the data sql
SQL
2 votes307 views1 answer
Convert series number to date in sql
SQL
2 votes340 views1 answer
Removing view
SQL
0 vote334 views1 answer
Add computed column to table sql server
SQL
-1 vote369 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote344 views1 answer
Example database query
SQL
22 votes404 views1 answer
Mysql workbench
SQL
1 vote339 views1 answer
How to unlock table in mysql
SQL