mysql 循环、游标

mysql 循环只能在存储过程。代码记录

CREATE DEFINER=`front`@`%` PROCEDURE `a_1`()
BEGIN

  -- 声明变量，接收游标循环变量
  DECLARE _comid INT;
    -- 遍历数据结束标志
  DECLARE done INT DEFAULT 1;
  
  -- 游标
  DECLARE cur CURSOR FOR select CompanyId From tbcompany ;
  -- 游标循环结束设置结束标志为null
  declare CONTINUE HANDLER FOR SQLSTATE '02000' SET done = null;
  set done = 1;
  -- 打开游标
  OPEN cur;
  -- 开始循环
   WHILE ( done is not null) DO
      FETCH cur INTO _comid;
      if done is not null then
                 --  TODU 业务代码
           call company_changeAccount(72,_comid);
      end if;
  END WHILE;
  -- 关闭游标
  CLOSE cur;
END