循环中的SQL查询累加每个循环

import mysql.connector

# 连接到数据库
cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
cursor = cnx.cursor()

# 初始化累加变量
total = 0

# 循环开始
for i in range(1, 11):
    # 编写SQL查询语句
    query = "SELECT SUM(value) FROM table_name WHERE condition = {}".format(i)
    
    # 执行查询
    cursor.execute(query)
    
    # 获取查询结果
    result = cursor.fetchone()[0]
    
    # 累加结果到total变量
    total += result

# 关闭数据库连接
cursor.close()
cnx.close()

# 输出累加结果
print("Total: ", total)