jav901010的博客

MySQL存储过程遍历游标用loop嵌套循环的例子一、表的结构 CREATE TABLE T_GROW_POINT_STATISTICS ( GROW_POINT_STATISTICS_ID int(11) NOT NULL AUTO_INCREMENT COMMENT ‘主键’, GROW_GROUP_ID int(11) DEFAULT NULL COMMENT ‘拓客活动组ID’

CREATE DEFINER=`root`@`%` PROCEDURE `procInitData`(IN sId1 INT,IN sId2 INT,IN sId3 INT,IN sId4 INT,IN sId5 INT,IN sId6 INT,IN sId7 INT,IN sId8 INT,IN sId9 INT,IN sId10 INT,IN pName VARCHAR(50))BEGIN...