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.