mysql存储过程

BEGIN
DECLARE _done int DEFAULT 0;
DECLARE atdId INT;
DECLARE biId INT;
DECLARE atdDepid INT;
DECLARE abiDepid INT;
DECLARE applicant1 INT;
DECLARE _tdCur CURSOR FOR
SELECT ID,BASICINFO_ID,DEPT_ID FROM T_ACCOUNT_TRAVEL_DISTRIBUTION WHERE BASICINFO_ID IN (164833,165144,165318,165795,165798,165811,165959,166148,166154,166166,166219,166240,166267,166314,166318,166329,166562,166658,166670,166680);
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET _done = 1;
OPEN _tdCur;
WHILE _done<>1 DO
FETCH _tdCur INTO atdId,biId,atdDepid;
SELECT APPLICANT INTO applicant1 FROM T_ACCOUNT_BASICINFO WHERE ID=biId;
SELECT Department_ID INTO abiDepid FROM UserT WHERE User_ID=applicant1;
#UPDATE T_ACCOUNT_TRAVEL_DISTRIBUTION SET DEPT_ID=abiDepid WHERE ID=atdId;
END WHILE;
CLOSE _tdCur;
END