Python SQLite insert data with variable

Question

Can't insert variable to sqlite db

def new_player(nickname):
    conn = sqlite3.connect('db/pythonsqlite.db')
    c = conn.cursor()
    c.execute("INSERT  INTO Players VALUES (NULL, ?)", (nickname))
    conn.commit()
    conn.close()
new_player(nickname)

I get this error:

sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 7 supplied.

7 is the number of letters in nickname string

c.execute("INSERT INTO Players VALUES (NULL, ?)", (nickname,)) — sahasrara62
– sahasrara62, Commented Nov 2, 2020 at 15:33
Does this answer your question? sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied — sahasrara62
– sahasrara62, Commented Nov 2, 2020 at 15:33

buran · Accepted Answer · 2020-11-02 15:24:36Z

3

it should be

c.execute("INSERT  INTO Players VALUES (NULL, ?)", (nickname,))

this way you supply one-element tuple. Note the comma.

answered Nov 2, 2020 at 15:24

buran

14.4k13 gold badges45 silver badges76 bronze badges

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

1 Comment

Tim Biegeleisen Over a year ago

Bonus +1 for making the binding value a one-element tuple.

Collectives™ on Stack Overflow

Python SQLite insert data with variable

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related