Regularly update the value status of table field columns (Stored Procedure + scheduled task)

The value status (Stored Procedure + scheduled task) of the regularly updated table field column now has two more tables, tcm and doc; db_count: id count1 2202 3003 2204 2225 240db_date: id t_date count 1 17:04:07 2202 15:04:07 2243 11:04:07 2254 17:04:07 3005 10:04:07 5006 --- stored procedure change db_count table count value is 0; DELIMITER // create procedure update_count () begin declare m date; DECLARE y CURSOR for select t_date from db_date; declare continue handler for sqlstate '100' SET k = 1; OPEN y; FETCH y INTO m; if sysdate ()> m THENUPDATE db_date t, db_count g SET g. count = 0 WHERE t. id = g. id; end if; CLOSE y; END // DELIMITER; ---- event. The event interval is 1 second, execute this event delimiter // create event my_countON schedule every 1 second dobegincall update_count (); end // DELIMITER; select * from db_count;