-- 以宣告的 groupbuySum 變數為例 查詢有資料 into 之后 值為0 我qq 177011712 答案 譚凡 跪求大神解救
CREATE PROCEDURE `init_president_day`(in startTimeV VARCHAR(30),in endTimeV VARCHAR(30))
begin
declare groupbuySum decimal(12,2);
declare vidtmp int(12);
declare startTime DATETIME DEFAULT DATE_FORMAT(startTimeV,'%Y%m%d');
declare endTime DATETIME DEFAULT DATE_FORMAT(endTimeV,'%Y%m%d');
declare startTimeStr VARCHAR(20);
-- 遍歷資料結束標志
DECLARE done INT DEFAULT FALSE;
/* 宣告游標 */
DECLARE rs CURSOR FOR SELECT vid FROM t_manager_village where vid=80;
-- 將結束標志系結到游標
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
-- 打開游標
OPEN rs;
-- 遍歷
read_loop: LOOP
-- 取值 取多個欄位
FETCH NEXT from rs INTO vidtmp;
IF done THEN
LEAVE read_loop;
END IF;
-- 業務
set startTime =DATE_FORMAT(startTimeV,'%Y%m%d');
while startTime<endTime do
set startTimeStr =DATE_FORMAT(startTime,'%Y%m%d');
select ifnull(sum(sum),0) into groupbuySum from t_groupbuyorder where pay_time is not null and DATE_FORMAT(pay_time,'%Y%m%d')=startTimeStr and vid=vidtmp ;
set startTime=date_add(startTime, interval 1 day);
end while;
END LOOP;
CLOSE rs;
END
uj5u.com熱心網友回復：
FETCH rs INTO vidtmp;不是這樣嗎
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/102413.html
標籤：MySQL
上一篇：mongodb 計算