How to keep statistics?

Question

PHP

Hello, help with advice on how to keep statistics correctly, there is a site and there are a lot of simultaneous visits, I did this: for each page of the site in the database there is a column with the number of visits and on each visit I loaded the old value and added one. But what if two people entered at the same time? I just noticed that at some points the statistics even decrease, for example, it was 56 and it became 55. What is the best way to do it so as not to lose the number of views?

Answer 1

UPDATE statistic SET counter = counter + 1 WHERE page = ?