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 vote296 views3 answers
How to create a table structure from another table in mysql
SQL
9 votes267 views3 answers
Oracle undo usage by session
SQL
0 vote270 views2 answers
Sql join on wildcard
SQL
0 vote275 views1 answer
Monthly Birthday SQL Query
SQL
0 vote273 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote272 views1 answer
Commit transaction sql
SQL
0 vote305 views1 answer
Oracle insert single quote in string
SQL
0 vote261 views1 answer
Postgresql create table with boolean column
SQL
0 vote289 views1 answer
Sql set data from a select query to a temp table and insert
SQL
0 vote257 views1 answer
Oracle query to see what scema i am working in
SQL