mysql - 游标-MySQL游标在循环中此位置的下一个FETCH不是有效输入

如何解决从游标到MySQL中数据的FETCH next语法错误？

read_loop: LOOP
FETCH next from cur1 INTO id1, userId1, major1,minor1,beaconZone1;
IF done THEN
  LEAVE read_loop;
else
  INSERT INTO test VALUES (id1, userId1, major1,minor1,beaconZone1);
END IF;
END LOOP;

最佳答案

read_loop: LOOP
FETCH next from cur1 INTO id1, userId1, major1,minor1,beaconZone1;
IF done THEN
  LEAVE read_loop;
  CLOSE cursor_name;
else
  INSERT INTO test VALUES (id1, userId1, major1,minor1,beaconZone1);
END IF;
END LOOP;