How to write information to sql using the WHERE method?

Question

Python

cur.execute(f"""INSERT INTO HGF (id_, Алгебра_1) VAlUES(?, ?) WHERE id_ = 0""", (1, A),)

Error:
sqlite3.OperationalError: near "WHERE": syntax error

Answer 1

INSERT does not require WHERE, as it creates a new record in the table.
If you need to update an existing entry, use UPDATE.

Answer 2

Try like this

cur.execute(f"""INSERT INTO HGF (id_, Алгебра_1) VAlUES(?, ?) WHERE id_ = "0"""", (1, A),)