Changing row data in SQLite table, without deleting and re-inserting updated values again

I made SQLite database table that stores records, is it po开发者_StackOverflow中文版ssible to change some values that stored inside the table without deleting and entering updated values with older one.

e.g. Lets say I want to change the wage of row ID = 0 to from 23$ to 40$ without deleting the first row and reinserting making the auto incremented ID change to 1, is to possible?!

---

Yes, you should use an UPDATE statement.

---

Yes, check out the UPDATE syntax of SQLite.