mysql 循环查询结果集

import mysql.connector

# 连接到MySQL数据库
db = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

cursor = db.cursor()

# 执行查询
cursor.execute("SELECT * FROM yourtable")

# 循环遍历结果集
for row in cursor:
  print(row)

# 关闭连接
cursor.close()
db.close()

DELIMITER //

CREATE PROCEDURE ProcessRows()
BEGIN
  DECLARE done INT DEFAULT FALSE;
  DECLARE v_id INT;
  DECLARE v_name VARCHAR(255);

  -- 声明游标
  DECLARE cur CURSOR FOR SELECT id, name FROM yourtable;

  -- 声明继续处理的条件
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

  -- 打开游标
  OPEN cur;

  -- 循环遍历结果集
  read_loop: LOOP
    FETCH cur INTO v_id, v_name;
    IF done THEN
      LEAVE read_loop;
    END IF;

    -- 在这里执行你需要的操作
    -- 例如：UPDATE another_table SET status = 'processed' WHERE id = v_id;
  END LOOP;

  -- 关闭游标
  CLOSE cur;
END //

DELIMITER ;