Query regarding python database programming

Question

I am using the below code to delete a row from sqlite table.

def deleteFromTable(item):
    conn = sqlite3.connect("lite.db")
    cur = conn.cursor()
    cur.execute("DELETE FROM store WHERE item=?", (item,))
    conn.commit()
    conn.close()

Why do i need to use comma after item (item,) while passing the argument?

NobbyNobbs · Accepted Answer · 2018-05-27 21:51:48Z

1

('String') evaluates into string, but ('string',) evaluates into tuple. that's why you need comma.

answered May 27, 2018 at 21:51

NobbyNobbs

1,4441 gold badge12 silver badges17 bronze badges

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

1 Comment

Asim Dinda Over a year ago

Thank you very much

Collectives™ on Stack Overflow

Query regarding python database programming

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related