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 vote290 views1 answer
Mysql multiple count
SQL
0 vote282 views1 answer
Sum values by month mariadb
SQL
5 votes270 views1 answer
Oracle get nls settings
SQL
0 vote287 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote356 views1 answer
Mysql get nested records
SQL
1 vote289 views1 answer
Rermove categories woocommerce sql
SQL
0 vote305 views1 answer
Psql show db
SQL
25 votes279 views3 answers
Mysql command show tables
SQL
2 votes287 views1 answer
Sql column values comma separated
SQL
0 vote282 views1 answer
T sql less than date
SQL