How to change the value in the database?

Question

SQLite

You need to rank posts.
I have a database with a table "Comments" of the form:

id
text
author
post_id
like (default = 0)

You need to do +1 when you click on the button.
(Use a form? What if there is already a form on the page? Use prefixes?)

Answer 1

in Transact SQL I do like this

UPDATE [base].[shema].[table] SET [like] += 1 WHERE [id]=1