python cursor FROM %s

Question

I try to execute this request :

cur.execute("SELECT MAX(id) FROM %s WHERE equipement_id = %s", (table,eq_id))

But i have error because the FROM %s is not build correctly.

Answer 1

Try like this

cur.execute("""SELECT MAX(id) FROM %s WHERE equipement_id = %s""" % (table, eq_id))