This is a simple query to increment row value in MySQL. And this eliminates the need of code in php or other server side scripts.
Here, 'N' may be any number want to increment by.
UPDATE tablename SET column_name=column_name + N where clause;
Hence, the particular row will get updated increment by 1.
UPDATE tablename SET views = views + 1 where id=id;