mysql存储过程，游标嵌套，判断条件

#判断游标是否存在，存在则删除
DROP PROCEDURE
IF EXISTS statisticalPingTime;


#申明一个游标，并带输入参数
CREATE PROCEDURE statisticalPingTime (IN p_date VARCHAR(100))
BEGIN
DECLARE done Boolean DEFAULT TRUE;


DECLARE d_userId VARCHAR (100);


DECLARE d_name VARCHAR (100);


DECLARE d_email VARCHAR (100);


DECLARE d_ip VARCHAR (100);


DECLARE d_dept VARCHAR (100);


DECLARE d_PersonID VARCHAR (100);


#申明游标　查询a_user中所有符合条件的数据
DECLARE
userCursor CURSOR FOR SELECT
u.userId,
u. NAME,
u.email,
u.ip,
u.dept,
u.PersonID
FROM
a_user u
WHERE
u.delFlag = 0;


#每个游标必须使用不同的declare continue handler for not found set done=false来控制游标的结束
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = FALSE;


#打开游标
OPEN userCursor;


#得到游标中的第一条数据
FETCH userCursor INTO d_userId,
 d_name,
 d_email,
 d