MySQL Event Help – Update column value for each row every 15 minutes

Run this in MySQL

SET GLOBAL event_scheduler = ON;

Add this to my.cnf so the scheduler remains enabled upon mysql restart

[mysqld]
event_scheduler = ON

Start the Event on the Next Hour, Make it Recurring Every Hour, Adjusting WHERE clause

CREATE EVENT hourly_temp_avg
    ON SCHEDULE
    EVERY HOUR
    STARTS DATE(NOW()) + INTERVAL (HOUR(NOW())+1) HOUR
    ON COMPLETION PRESERVE
DO
INSERT INTO `table1` (`dateavg`, `avg_temperature`) 
SELECT `DATE` , avg(`temperature`)
FROM `new_table`
WHERE `date` >= NOW() - INTERVAL 1 HOUR;

Masoud came up with the proper concept first. So, he gets +1 from me.

It seem that your event scheduler is not running causing the problem of event not getting executed. use following command to check

show global variables like 'event_scheduler';

if you get that it is off, you can do if you are in MySQL 5.6 or higher

 set global event_scheduler=1;

or add the following line in cnf file to make this change permanent and in versions <5.6

 event_scheduler=ON

The given code would work once you turn on the event scheduler using above approach.

Hope it helps.