mysql数据库中如何遍历查询

DELIMITER //

CREATE PROCEDURE TraverseTable()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE id INT;
    DECLARE name VARCHAR(255);
    
    -- 声明游标
    DECLARE cur CURSOR FOR SELECT id, name FROM your_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    
    OPEN cur;
    
    read_loop: LOOP
        FETCH cur INTO id, name;
        IF done THEN
            LEAVE read_loop;
        END IF;
        
        -- 在这里执行对每一行的操作
        -- 例如，打印每一行的id和name
        SELECT CONCAT('ID: ', id, ', Name: ', name) AS result;
    END LOOP;
    
    CLOSE cur;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE TraverseTableWithCursor()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE id INT;
    DECLARE name VARCHAR(255);
    
    -- 声明游标
    DECLARE cur CURSOR FOR SELECT id, name FROM your_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    
    OPEN cur;
    
    read_loop: LOOP
        FETCH cur INTO id, name;
        IF done THEN
            LEAVE read_loop;
        END IF;
        
        -- 在这里执行对每一行的操作
        -- 例如，打印每一行的id和name
        SELECT CONCAT('ID: ', id, ', Name: ', name) AS result;
    END LOOP;
    
    CLOSE cur;
END //

DELIMITER ;

import mysql.connector

def traverse_table():
    conn = mysql.connector.connect(user='your_user', password='your_password', host='your_host', database='your_database')
    cursor = conn.cursor(dictionary=True)
    
    cursor.execute("SELECT id, name FROM your_table")
    
    for row in cursor:
        # 在这里执行对每一行的操作
        print(f"ID: {row['id']}, Name: {row['name']}")
    
    cursor.close()
    conn.close()

traverse_table()