Python中根据列表元素个数动态创建Mysql查询

import pymysql

conn = pymysql.connect(host='localhost', port=3306, user='root', password='your_password', db='your_database')

cursor = conn.cursor()

table_name = 'your_table'
column_names = ['column1', 'column2', 'column3']  # 列名列表
placeholders = ', '.join(['%s']*len(column_names))  # 占位符字符串

sql = f"SELECT * FROM {table_name} WHERE {placeholders}"

cursor.execute(sql, column_names)

results = cursor.fetchall()

cursor.close()
conn.close()

import pymysql

def dynamic_mysql_query(table_name, column_names):
    conn = pymysql.connect(host='localhost', port=3306, user='root', password='your_password', db='your_database')
    cursor = conn.cursor()

    placeholders = ', '.join(['%s']*len(column_names))
    sql = f"SELECT * FROM {table_name} WHERE {placeholders}"

    cursor.execute(sql, column_names)
    results = cursor.fetchall()

    cursor.close()
    conn.close()

    return results