mysql怎么循环查询数据库

DELIMITER //

CREATE PROCEDURE BatchUpdate()
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE max_id INT;
    
    SELECT MAX(id) INTO max_id FROM your_table;
    
    WHILE i <= max_id DO
        UPDATE your_table SET status = 'updated' WHERE id = i;
        SET i = i + 1;
    END WHILE;
END //

DELIMITER ;

import mysql.connector

# 连接数据库
db = mysql.connector.connect(
    host="localhost",
    user="your_user",
    password="your_password",
    database="your_database"
)

cursor = db.cursor()

# 循环查询
for i in range(1, max_id + 1):
    cursor.execute("UPDATE your_table SET status = 'updated' WHERE id = %s", (i,))
    db.commit()

cursor.close()
db.close()