mysql存储过程中使用了游标和临时表，返回的临时表数据不准确

DECLARE done INT DEFAULT FALSE; 创建游标DECLARE cur_usname CURSOR FOR SELECT parentname FROM user_chilld WHERE childname=uname;DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;创建临时表 CREATE TEMPORARY TABLE IF NOT EXISTS tmp_sportdata( totala INT(11), ranking INT(11), totalamonth INT(11), rankmonth INT(11), totaladay INT(11), rankday INT(11), usname VARCHAR(64));OPEN cur_usname;read_loop: LOOPFETCH cur_usname INTO usname;IF done THEN LEAVE read_loop;END IF; SET @mytemp = 0; SELECT newid,stotal,usname INTO ranking,totala,usname FROM( SELECT (@mytemp:=@mytemp+1) AS newid,stotal,username FROM ( SELECT SUM(total) stotal, username FROM exercise WHERE ( username IN( SELECT username FROM ofRoster WHERE jid=CONCAT(usname,jidb) OR username =usname) AND createtime BETWEEN starttime AND endtime )GROUP BY username ORDER BY stotal DESC )a ) a1 WHERE username=usname;SET @mytemp = 0;SELECT newid,stotal INTO rankmonth,totalamonth FROM( SELECT (@mytemp:=@mytemp+1) AS newid,stotal,username FROM ( SELECT SUM(total) stotal, username FROM exercise WHERE ( username IN( SELECT username FROM ofRoster WHERE jid=CONCAT(usname,jidb) OR username =usname) AND createtime BETWEEN startmonth AND endmonth )GROUP BY username ORDER BY stotal DESC )a ) a1 WHERE username=usname;SET @mytemp = 0;SELECT newid,stotal INTO rankday,totaladay FROM( SELECT (@mytemp:=@mytemp+1) AS newid,stotal,username FROM ( SELECT SUM(total) stotal, username FROM exercise WHERE ( username IN( SELECT username FROM ofRoster WHERE jid=CONCAT(usname,jidb) OR username =usname) AND createtime BETWEEN startday AND startday )GROUP BY username ORDER BY stotal DESC )a ) a1 WHERE username=usname; INSERT INTO tmp_sportdata VALUES(totala,ranking,totalamonth,rankmonth,totaladay,rankday,usname); END LOOP; CLOSE cur_usname; SELECT * FROM tmp_sportdata; DROP TABLE IF EXISTS tmp_sportdata;END$$