Why does this line of code, instead of changing the value in the table, just add a new one?

Question

SQLite

c.execute("INSERT INTO bustbuy VALUES ({0}, 'Да', 'Нет', 'Нет','none')".format(message.chat.id))

It does not update, but simply creates a new row in the database.

Answer 1

Because the INSERT command adds a new record.
If you want to change an existing one - use UPDATE