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 vote365 views1 answer
Oracle sequence last_number
SQL
7 votes358 views1 answer
Safe update mysql
SQL
0 vote394 views2 answers
Mysql insert into multiple tables
SQL
0 vote400 views1 answer
Mariadb create index if not exists
SQL
0 vote365 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote392 views1 answer
How to fetch data from database in sql
SQL
0 vote339 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote352 views1 answer
Get cpu details sql
SQL
0 vote349 views1 answer
Oracle create package specification
SQL
0 vote371 views1 answer
Sql menampilkan data tabel
SQL