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.

Thanks.

1 Answers
George
George

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