mysql游标嵌套游标_mysql 游标的嵌套使用示例

BEGIN

DECLARE trainee_no_value BIGINT (20); -- 学员编号

DECLARE pay_no_value BIGINT (20); -- 交费序号

DECLARE deposit_value BIGINT (20); -- 预定金

DECLARE pay_type_value CHAR (2); -- 交费性质

DECLARE done INT DEFAULT FALSE;

DECLARE startSynctime datetime DEFAULT NOW();

-- 异常信息变量

DECLARE eerrorcode CHAR(5);

DECLARE msg TEXT;

DECLARE trainee_no_cur CURSOR FOR

SELECT TRAINEE_NO,PAY_NO,DEPOSIT,PAY_TYPE FROM trainee_pay_info

WHERE

DELETE_KBN = '0'

AND PAY_AMOUNT > 0

AND PAY_KBN = '02'

AND DEPOSIT > 0

AND TRUE_FINANCE_TIME IS NOT NULL

AND PAY_TYPE IN ('01','03','04')

ORDER BY TRAINEE_NO ASC,PAY_NO DESC;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

-- 异常检测和信息的存储

DECLARE EXIT HANDLER FOR SQLEXCEPTION

BE