mysql存储过程-优快云博客

本文链接：https://blog.youkuaiyun.com/changyuan101/article/details/51201062

本文介绍了HeidiSQL在数据导出导入方面的便捷性，以及dbForge Studio for MySQL在调试存储过程时的实用功能。特别强调了在遍历时，避免游标数据命名与自定义变量命名冲突的重要性。通过实例代码演示了如何高效地遍历游标并插入数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

HeidiSQL导出导入数据比较方便

dbForge Studio for MySQL 调试存储过程

地址：http://www.liangchan.net/liangchan/4715.html

遍历游标时注意游标中数据命名不能和自定义变量命名相同。

begin
declare flowsize1 int default 0;
declare vsimimsi1,visitcountry1,daytime1 varchar(50);
declare cur_flowlog cursor for
select vsimimsi, visitcountry,date_format(beginTime,'%Y-%m-%d')as daytime,sum(flowSize) as flowsize
from `t_chgflow` where 1=1 group by daytime,vsimimsi,visitcountry;
open cur_flowlog;
cur_flowlog:loop
fetch cur_flowlog into vsimimsi1,visitcountry1,daytime1,flowsize1;
INSERT INTO t_chgflowlog (`vsimimsi`, `visitcountry`, `daytime`, `flowsize`) VALUES (vsimimsi1, visitcountry1,daytime1,flowsize1);
end loop cur_flowlog;
close cur_flowlog;
end

begin
declare _flowsize int default 0;
declare _vsimimsi,_visitcountry,_daytime varchar(50);
declare _done int default 0;
declare cur_flowlog cursor for
select vsimimsi, visitcountry,date_format(beginTime,'%Y-%m-%d')as daytime,sum(flowSize) as flowsize
from `t_chgflowlog001` where 1=1 group by daytime,vsimimsi,visitcountry;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET _done = 1;#错误定义，标记循环结束
open cur_flowlog;
fetch cur_flowlog into _vsimimsi,_visitcountry,_daytime,_flowsize;
WHILE ( _done <> 1) DO
INSERT INTO t_chgflowlog_statistics (`vsimimsi`, `visitcountry`, `daytime`, `flowsize`) VALUES (_vsimimsi, _visitcountry,_daytime,_flowsize);
fetch cur_flowlog into _vsimimsi,_visitcountry,_daytime,_flowsize;
END WHILE;
close cur_flowlog;
end