如何从表中获取所有数据，如果同一列中相同的值重复，则该行应该计数一次？

import mysql.connector

# 连接数据库
conn = mysql.connector.connect(
    host="localhost",
    user="your_username",
    password="your_password",
    database="your_database"
)

# 创建游标对象
cursor = conn.cursor()

# 查询数据
query = "SELECT * FROM your_table"
cursor.execute(query)

# 数据处理和计数
count_dict = {}
for row in cursor.fetchall():
    for value in row:
        if value in count_dict:
            count_dict[value] += 1
        else:
            count_dict[value] = 1

# 输出结果
for value, count in count_dict.items():
    print(f"{value}: {count}")

# 关闭游标和数据库连接
cursor.close()
conn.close()