BEGIN
DECLARE numbe INTEGER;
DROP TABLE IF EXISTS tmp_table;
CREATE TEMPORARY TABLE tmp_table ( id INTEGER,publicTime date,totalDownloadCount INTEGER,totalUserCount INTEGER);
set numbe=var+7;
while numbe>var DO
insert into tmp_table value(numbe-1,(select DATE_SUB(CURDATE(), INTERVAL numbe-2 DAY)),(select COUNT(DISTINCT deviceId) from accesselog where date(time) <= DATE_SUB(CURDATE(), INTERVAL numbe-2 DAY)),(select COUNT(1) from user where date(regitsterTime) <= DATE_SUB(CURDATE(), INTERVAL numbe-2 DAY)));
set numbe=numbe-1;
end WHILE;
end
Mysql存储过程,获取最近7天