sql - cursor execute how to create string

Question

I see formatting string using the string formatting is not advisable as it is prone to different problems.

However, I do not like embedding the values in the cursor. execute directly.

How I can build the string separately?

cursor.execute("INSERT INTO table VALUES (%s, %s, %s)", (var1, var2, var3))

I am using python.

Is there a way to separate this?

Answer 1

等待大神答复