create procedure testCur()
BEGIN
-- 需要定义接收游标数据的变量
declare row_id int;
DECLARE done INT DEFAULT FALSE;
-- 游标
DECLARE cur CURSOR FOR select id from users where DATEDIFF('2018-06-28 13:00:00',updatetime)<days;
-- 遍历数据结束标志
-- 将结束标志绑定到游标
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
-- 打开游标
OPEN cur;
-- 开始循环
read_loop: LOOP
IF done THEN
LEAVE read_loop;
end if;
-- 开始循环
FETCH cur INTO row_id;
update users set days=DATEDIFF('2018-09-15 13:00:00',updatetime) where id=row_id;
end LOOP;
CLOSE cur;
END