如何循环从多个表中获取计数？

import mysql.connector

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

# 定义要获取计数的表
tables = ['table1', 'table2', 'table3']

# 存储计数结果的字典
count_results = {}

# 循环遍历每个表
for table in tables:
    # 构建查询语句
    query = "SELECT COUNT(*) FROM {}".format(table)
    
    # 执行查询
    cursor = cnx.cursor()
    cursor.execute(query)
    
    # 获取计数结果
    count = cursor.fetchone()[0]
    
    # 将计数结果存储到字典中
    count_results[table] = count
    
    # 关闭游标
    cursor.close()

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

# 打印计数结果
for table, count in count_results.items():
    print("表 {} 的计数结果为: {}".format(table, count))