Sqlite sqlite3.OperationalError: no such column: hello how to fix?

Question

Python

code:

connection = sqlite3.connect(db)
q = connection.cursor()
q.execute(f"UPDATE earn SET text = hello WHERE user_id={message.chat.id}")

error:

sqlite3.OperationalError: no such column hi

please help me fix this error

Answer 1

Let's go like this:

connection = sqlite3.connect(db)
q = connection.cursor()
q.execute(f"UPDATE earn SET text = 'привет' WHERE user_id={message.chat.id}")