python - Python - 将字段列表作为列传递给 SQL 查询

Question

我正在尝试将列列表传递给 Python 中的 SQL 查询。这只是返回列表，而不是实际的列，如图所示：

cols = ["col_a","col_b","col_c"]


query = f"""select '{cols}' from table"""


Current Output : f"""select '["col_a","col_b","col_c"]' from table"""

Expected output: f"""select col_a, col_b, col_c from table"""

标签： pythonsql

Answer 1

你想做一个join列表：

query = f"""select {", ".join(cols)} from table"""