Python SQLite3 multiple variables in SELECT

Question

I am trying to do something like this

cur.execute('''SELECT ID FROM ? WHERE Name = ?''', (var1,var2) )

but got a error message of syntax error near "?"

I have also tried

 cur.execute("SELECT ID FROM" + var1 + "WHERE Name = ?", (var2,))

same error happened

Zbynek Vyskovsky - kvr000 · Accepted Answer · 2016-02-05 07:08:45Z

1

You can't use placeholder for names of columns or tables.

The second example fails because of missing spaces. Correct to:

cur.execute("SELECT ID FROM " + var1 + " WHERE Name = ?", (var2,))

answered Feb 5, 2016 at 7:08

19.1k3 gold badges41 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1