mysql变量赋值要注意的_MySQL

Sql代码  CREATE FUNCTION `getChildLstnotSun`(department_id int)   RETURNS varchar(1000)    BEGIN      DECLARE sTemp VARCHAR(1000);      DECLARE sTempChd int;      declare fetchSeqOk boolean;     declare cur1 CURSOR FOR SELECT departmentId FROM sys_department_info where fatherDepartmentId=department_id;       DECLARE CONTINUE HANDLER FOR NOT FOUND SET fetchSeqOk=true;       SET fetchSeqOk=false;     OPEN cur1;       fetchSeqLoop:Loop              FETCH cur1 INTO sTempChd;              if fetchSeqOk then                    leave fetchSeqLoop;                else                      SET sTemp := concat(sTemp,',',sTempChd);               end if;        end loop;       CLOSE cur1;      RETURN sTemp;    END   

Sql代码  OPEN cur1;      fetchSeqLoop:Loop          FETCH cur1 INTO sTempChd;          if fetchSeqOk then                leave fetchSeqLoop;            else                  SET sTemp := concat(sTemp,',',sTempChd);           end if;        end loop;  CLOSE cur1;