How to increment/decrements MySQL value

This syntax allow's you to increment or decrements MySQL value without first reading the MySQL value.


This code enables you to increment MySQL value:

   UPDATE exam SET exam_taken=exam_taken +1 WHERE id=15    

exam is your table
exam_taken and id is structure column




This code enables you to decrement MySQL value:

   UPDATE exam SET exam_taken=exam_taken -1 WHERE id=15    

exam is your table
exam_taken and id is structure column

Visit my site Click here