Why am I getting "sqlite3.OperationalError: no such column: test" error?

Question

Python

There is a table

cursor_voice.execute("""CREATE TABLE IF NOT EXISTS voice_data(
            c_name TEXT,
            c_id INT,
            v_name TEXT,
            v_id INT
        )""")

I want to update the values ​​​​in it (name_category contains the value test):

cursor_voice.execute("UPDATE voice_data SET c_name =  {}".format(name_category))
cursor_voice.execute("UPDATE voice_data SET c_id = {}".format(category_private.id))
cursor_voice.execute("UPDATE voice_data SET v_name = {}".format(voice_private))
cursor_voice.execute("UPDATE voice_data SET v_id = {}".format(voice_private.id))
voice.commit()

An error is thrown:

cursor_voice.execute("UPDATE voice_data SET c_name = {}".format(name_category))
sqlite3.OperationalError: no such column: test

How to solve it?

Answer 1

Queries with parameters in SQLite
Try this:

cursor_voice.execute("UPDATE voice_data SET c_name=?",(name_category,))

Only I do not understand the meaning of this request.

Answer 2

Because it is not necessary to substitute values ​​in the sql query using string formatting.