Direct sum by SQL query

Question

I wonder if there is a way I can make a simple sum directly by the query, I have a table that contains a sub-table called VIEWS and I would like for each query that I run these VIEWS to increase +1 without I need to exercise PHP a lot, how can I do this?

Answer 1

Assuming the table has a field called contador and this is increased:

UPDATE minhatabela SET contador = contador + 1 WHERE pagina = (id da pagina desejada)

(Where is also there for example purposes. For more details, edit the question and add the details you need).