在Python中将SQL Where IN子句When List is to big拆分为较小的请求

import pymysql

# 假设大列表为list_to_split，每个子列表包含10个元素
list_to_split = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20]

# 将大列表分割为每个子列表包含10个元素的子列表
split_size = 10
sub_lists = [list_to_split[i:i+split_size] for i in range(0, len(list_to_split), split_size)]

# 连接数据库
conn = pymysql.connect(host='localhost', user='username', password='password', db='database')

# 遍历子列表并发送请求
for sub_list in sub_lists:
    # 构建SQL查询语句
    sql = "SELECT * FROM table_name WHERE column_name IN (%s)" % ', '.join(['%s'] * len(sub_list))
    
    # 执行查询
    with conn.cursor() as cursor:
        cursor.execute(sql, sub_list)
        result = cursor.fetchall()
        # 处理查询结果
        
# 关闭数据库连接
conn.close()