mysql 循环查询记录

import mysql.connector

def fetch_data_in_batches(table_name, batch_size=100):
    conn = mysql.connector.connect(user='your_user', password='your_password', host='your_host', database='your_database')
    cursor = conn.cursor(dictionary=True)
    
    offset = 0
    while True:
        query = f"SELECT * FROM {table_name} LIMIT {batch_size} OFFSET {offset}"
        cursor.execute(query)
        records = cursor.fetchall()
        
        if not records:
            break
        
        # 处理记录
        for record in records:
            print(record)
        
        offset += batch_size
    
    cursor.close()
    conn.close()

# 调用函数进行分批查询
fetch_data_in_batches('your_table')