how to change a field automatically in phpmyadmin?

Asked May 14 '18 at 22:28

Active May 14 '18 at 22:28

Viewed 89 times

CREATE EVENT reset
    ON SCHEDULE
      EVERY 1 MINUTE
        DO
update name_of_table
set name_of_field = 1;

Or i have tried.

CREATE EVENT myevent 
ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 SECOND DO 
UPDATE locationofdriver 
   SET coordinate = 1;

asked May 14 '18 at 22:28

Aditya Dadhich

Have you verified that the MySQL event scheduler is enabled? `SHOW VARIABLES LIKE 'event_scheduler'` – spencer7593 May 14 '18 at 22:34
its off.. how to turn it on – Aditya Dadhich May 14 '18 at 22:40
https://stackoverflow.com/questions/17875797/how-to-enable-event-scheduler-when-i-open-mysql-server – spencer7593 May 15 '18 at 01:53
https://stackoverflow.com/questions/39158933/how-to-check-event-scheduler-status-mysql?s=3|104.7952 – spencer7593 May 15 '18 at 01:54
https://stackoverflow.com/questions/6622301/can-i-set-a-mysql-event-schedule-using-phpmyadmin/6622509#6622509 – spencer7593 May 15 '18 at 01:55

0 Answers0