mysql定义动态游标

import mysql.connector

def dynamic_cursor_example():
    # 连接到MySQL数据库
    db = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
    
    cursor = db.cursor(dictionary=True)
    
    # 定义查询
    query = "SELECT * FROM your_table"
    
    try:
        # 执行查询
        cursor.execute(query)
        
        # 动态处理结果集
        while True:
            result = cursor.fetchone()
            if result is None:
                break
            print(result)
    
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    
    finally:
        # 关闭游标和连接
        cursor.close()
        db.close()

if __name__ == "__main__":
    dynamic_cursor_example()