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 vote302 views1 answer
Search all sql tables for a value
SQL
20 votes260 views5 answers
Mysql reset auto increment to 1
SQL
0 vote298 views1 answer
MySQL INSERT IGNORE Statement
SQL
25 votes279 views4 answers
Metadata
SQL
14 votes289 views3 answers
Delete all records from table except sql
SQL
0 vote295 views1 answer
Oracle list partitions
SQL
7 votes290 views1 answer
Sql disable safe mode
SQL
2 votes387 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
4 votes283 views2 answers
Oracle unlock user
SQL
1 vote275 views1 answer
Sqlite create index
SQL