"No such column error" in sqlite3 in python

Question

I am getting the error while trying to insert values.

This is for storing userid and password of users in sqlite3 database.

import sqlite3, hashlib

conn = sqlite3.connect('user.db')

a = input("Enter id:")
b = input("Enter password:")
b = str.encode(b)
b = hashlib.sha224(b).hexdigest()

conn.execute("insert into user(id,pass) values(%s, %s);"%(a,b))
print("Done")

Create statement was:

CREATE TABLE user(id varchar[50], pass varchar[50])

When I try to enter values A(id) and a (password), I get the following error:

conn.execute("insert into user(id,pass) values(%s, %s);"%(a,b))
sqlite3.OperationalError: no such column: A

TrainTirade · Accepted Answer · 2019-11-06 16:57:43Z

1

You must use placeholders for the parameters.

So your code will become:

 conn.execute("insert into user(id,pass) values(? , ?);" , (a,b))

Another solution that is bad practice, because of the high risk of SQL injection is:

 conn.execute("insert into user(id,pass) values('%s', '%s');"%(a,b))

SQLite3 Python module documentation:

https://docs.python.org/3/library/sqlite3.html#sqlite3.Cursor.execute

edited Nov 6, 2019 at 16:57

TrainTirade

1068 bronze badges

answered Nov 3, 2019 at 23:32

EchoMike444

1,6921 gold badge12 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

"No such column error" in sqlite3 in python

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related