Insert into SQLITE Using single variable [duplicate]

Question

This question already has answers here:

SQLite parameter substitution problem (9 answers)

Closed 4 years ago.

What is the correct way to insert data into a single column in a table using a python variable?

I have tried

 crsr.execute("INSERT INTO PBI(Acceptance_Criteria) VALUES (?)",wi_criteria)
 connection.commit()

Gives Incorrect bindings error

crsr.execute(f"INSERT INTO PBI(Acceptance_Criteria) VALUES {wi_criteria})
connection.commit()

Gives Incomplete input

What is the correct format please? Thanks.

Answer 1

You should be passing a tuple as the second parameter to cursor.execute():

crsr.execute("INSERT INTO PBI (Acceptance_Criteria) VALUES (?)", (wi_criteria,))
connection.commit()

• Abhishek Rai: I think I tried that. Let me check. Aah..I didn't place the comma after wi_criteria