DELIMITER $$
CREATE PROCEDURE wheelSta()
BEGIN
DECLARE inexp,income,taks,c_count,t_taks, e,c INT;
DECLARE b INT DEFAULT 0; /*是否达到记录的末尾控制变量*/
DECLARE day_1,day_2 DATE;
DECLARE cur_1 CURSOR FOR SELECT COUNT,creat_time,taks FROM `cn_members_log` WHERE taks = 12 AND DATE(creat_time) = DATE_SUB(CURDATE(),INTERVAL 1 DAY);
DECLARE CONTINUE HANDLER FOR NOT FOUND SET b = 1;
OPEN cur_1;
FETCH cur_1 INTO c_count, day_1, t_taks; /*获取第一条记录*/
WHILE b=0 DO
INSERT INTO cn_members_sta(inexp,TIME,taks) VALUES(c_count, day_1, t_taks);
FETCH cur_1 INTO c_count, day_1, t_taks; /*取下一条记录*/
END WHILE;
CLOSE cur_1;
END$$
DELIMITER ;通过SELECT COUNT,creat_time,taks FROM `cn_members_log` WHERE taks = 12 AND DATE(creat_time) = DATE_SUB(CURDATE(),INTERVAL 1 DAY);这句可以查出4条记录,但是执行后在cn_members_sta表中却一条数据都没有,求解~
CREATE PROCEDURE wheelSta()
BEGIN
DECLARE inexp,income,taks,c_count,t_taks, e,c INT;
DECLARE b INT DEFAULT 0; /*是否达到记录的末尾控制变量*/
DECLARE day_1,day_2 DATE;
DECLARE cur_1 CURSOR FOR SELECT COUNT,creat_time,taks FROM `cn_members_log` WHERE taks = 12 AND DATE(creat_time) = DATE_SUB(CURDATE(),INTERVAL 1 DAY);
DECLARE CONTINUE HANDLER FOR NOT FOUND SET b = 1;
OPEN cur_1;
FETCH cur_1 INTO c_count, day_1, t_taks; /*获取第一条记录*/
WHILE b=0 DO
INSERT INTO cn_members_sta(inexp,TIME,taks) VALUES(c_count, day_1, t_taks);
FETCH cur_1 INTO c_count, day_1, t_taks; /*取下一条记录*/
END WHILE;
CLOSE cur_1;
END$$
DELIMITER ;通过SELECT COUNT,creat_time,taks FROM `cn_members_log` WHERE taks = 12 AND DATE(creat_time) = DATE_SUB(CURDATE(),INTERVAL 1 DAY);这句可以查出4条记录,但是执行后在cn_members_sta表中却一条数据都没有,求解~
CREATE PROCEDURE wheelSta()
BEGIN
DECLARE inexp,income,taks,c_count,t_taks, e,c INT;
DECLARE b INT DEFAULT 0; /*是否达到记录的末尾控制变量*/
DECLARE day_1,day_2 DATE;
DECLARE cur_1 CURSOR FOR SELECT COUNT,creat_time,taks FROM `cn_members_log` WHERE taks = 12 AND DATE(creat_time) = DATE_SUB(CURDATE(),INTERVAL 1 DAY);
DECLARE CONTINUE HANDLER FOR NOT FOUND SET b = 1;
OPEN cur_1;
FETCH cur_1 INTO c_count, day_1, t_taks; /*获取第一条记录*/
repeat
FETCH cur1 INTO ps_lsjlid, ps_ywid, ps_fwsj, ps_fwjssj, ps_ckid;
if not b then
INSERT INTO cn_members_sta(inexp,TIME,taks) VALUES(c_count, day_1, t_taks);
until b end
REPEAT;
CLOSE cur1;
commit;
END$$