Table name as variable in sql string

Question

can someone tell me how to make the table a variable?

tableX = "test"
sql = "SELECT * FROM tableX WHERE datum = %s and name = %s" 
val = (datumX, nameX,)

I just can't get it right. I've tried {}and also s%.

Thanks

• apet: try this: sql = f"SELECT * FROM {tableX} WHERE datum = %s and name = %s"
• jlandercy: Could you elaborate on what database you intend to connect and what connector you will use for that.
• OneCricketeer: How would you put a variable in any other string?

Answer 1

You can use format function or f-string(if python 3.6=<)

tableX = "test"
sql = "SELECT * FROM {} WHERE datum = %s and name = %s".format(tableX)

• Imhotep: Great with that, why is everything so complicated in Python :)

Answer 2

In Python2.x works first answer:

sql = "SELECT * FROM {} WHERE datum = %s and name = %s" .format(tableX)

In Python3 you can use second one with f-string:

sql = f"SELECT * FROM {tableX} WHERE datum = %s and name = %s"

But, beware of SQL injection. You must be absolutely sure about source of that tableX variable (no user input). By direct format of the string you by-pass all escaping of input.