mysql - Scheduled task doesn't run -
create event `set_trips_finished` on schedule every 1 day starts '2015-08-25 01:50:00' on completion preserve begin update trips set status = 0 date(created_at) < curdate(); end; is scheduled task. fields don't updated. when run query - fields updated fine. i have scheduled task, same syntax, scheduled run 5 minutes later, , runs fine. i don't understand why wouldn't task run, or whether query not update table... suggestions? update i deleted other scheduled task (the 1 working), , set them both again, , neither fires... see if event scheduler running: show variables variable_name='event_scheduler'; +-----------------+-------+ | variable_name | value | +-----------------+-------+ | event_scheduler | off | +-----------------+-------+ nope create test table: create table trips ( id int auto_increment primary key, status int not null, created_at date not null ); insert trips(status,created_at) values (...