mysql 游标使用_mysql的游标使用笔记

-- 定义游标

DECLARE ordernumbers CURSOR

FOR

SELECT callee_name FROM account_tbl where acct_timeduration=10800;

DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_departments=1;

SET no_more_departments=0;

-- 打开游标

OPEN ordernumbers;

-- 循环所有的行

REPEAT

-- Get order number

FETCH ordernumbers INTO o;

update account set allMoney=allMoney+72,lastMonthConsume=lastMonthConsume-72 where NumTg=@o;

-- 循环结束

UNTIL no_more_departments

END REPEAT;

-- 关闭游标

CLOSE ordernumbers;