What is wrong with sql query?

Question

Python

cur.execute('SELECT ? FROM ?', [column_name, table_name,])
for element in cur.fetchall():
result.append(element[0])
return result

When executing this code, an error occurs:
cur.execute('SELECT ? FROM ?', [column_name, table_name,]
sqlite3.OperationalError: near"?": syntax error

I don't understand what the problem is.

Answer 1

You cannot substitute column and table names.