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

2 votes176 views1 answer
Postgresql add entry to table
SQL
3 votes192 views1 answer
Start mysql server by terminal in linux
SQL
0 vote201 views1 answer
Check if a column is a primary key in sql server
SQL
3 votes192 views4 answers
Truncate syntax in sql
SQL
0 vote194 views1 answer
Convert polygon to text in mysql
SQL
1 vote194 views1 answer
Sql find column name like
SQL
0 vote227 views1 answer
Mysql faster delete
SQL
0 vote190 views1 answer
Select insert new table sql server
SQL
11 votes200 views5 answers
Laravel db facade
SQL
0 vote180 views1 answer
Mysql xampp reset root password
SQL