在每个表中搜索多个列名，并返回表名

import MySQLdb

def search_columns(table_names, column_names):
    result = []
    
    # 连接到数据库
    conn = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database_name')
    cursor = conn.cursor()
    
    # 获取所有表名
    cursor.execute("SHOW TABLES")
    tables = cursor.fetchall()
    
    # 对于每个表，获取列名并检查是否存在需要搜索的列名
    for table in tables:
        table_name = table[0]
        if table_name in table_names:
            cursor.execute("SHOW COLUMNS FROM " + table_name)
            columns = cursor.fetchall()
            column_names_in_table = [column[0] for column in columns]
            
            for column_name in column_names:
                if column_name in column_names_in_table:
                    result.append(table_name)
                    break
    
    # 关闭数据库连接
    cursor.close()
    conn.close()
    
    return result

# 调用函数并打印结果
table_names = ['table1', 'table2', 'table3']
column_names = ['column1', 'column2', 'column3']
result = search_columns(table_names, column_names)
print(result)