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

4 votes204 views3 answers
Rename table column postgresql
SQL
1 vote205 views1 answer
Mysql view current queries
SQL
0 vote223 views1 answer
Cube oracle
SQL
0 vote198 views1 answer
Soql more than today
SQL
12 votes240 views4 answers
How to drop all tables in postgresql
SQL
1 vote199 views2 answers
Replace text in sql
SQL
4 votes215 views3 answers
Mysql get column names from table
SQL
3 votes206 views2 answers
Enter mysql command line
SQL
24 votes218 views6 answers
Alter table name sql
SQL
1 vote195 views1 answer
Sql drop with dependencies
SQL