How to change last column in sqlite python?

Question

SQLite

I have a sqlite table and I need to change a value in it. The thing is, I have multiple rows with the same key. How can I change only the last line with the hello key?

Answer 1

> The fact is that I have several rows with the same key.
So you do not have a primary key in the table, since the primary key must be unique.
Correct the structure of the table so that there is a truly unique key, then there will be no such problems.

Answer 2

The matter is that at me some lines with the same key. How can I change only the last line with the hello key?

Suck all records with this key;
Sort by id;
Select the first entry.
Clue:

SELECT * FROM my_table WHERE my_key='Hello wrot' ORDER BY 'id' DESC LIMIT 1;

I can’t vouch for pronunciation, that’s why it’s a hint, not a ready-made answer.