从列有特定值的所有表中选择表名

import pymysql

def select_table_names_with_specific_value(column_name, specific_value):
    # 连接数据库
    conn = pymysql.connect(host='localhost', port=3306, user='username', password='password', db='database_name')
    cursor = conn.cursor()

    # 查询数据库中所有的表名
    cursor.execute("SHOW TABLES")
    tables = cursor.fetchall()

    # 遍历每个表名
    result = []
    for table in tables:
        table_name = table[0]

        # 判断该表中是否存在特定值的列
        cursor.execute(f"SELECT COUNT(*) FROM {table_name} WHERE {column_name} = '{specific_value}'")
        count = cursor.fetchone()[0]

        if count > 0:
            result.append(table_name)

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

    return result

# 示例用法
column_name = 'column_name'
specific_value = 'specific_value'
result = select_table_names_with_specific_value(column_name, specific_value)
print(result)