How to increase value for a int column in SQL query?

I want to calculate page view count from MySQL while customers open that particular page. As per my request I want to add count increment whenever customer open that page. help me to get solution for this.


1 Answers

Hi, you can get solution for this by simply using the below query 

UPDATE page SET view = view + 1 WHERE pageid=1
Add Your Answer