How to add 1 to the value of a column of an existing row in mysql

Question

Hello everyone,

I have a table called pollData. It will always contain only 1 row. It has columns option1, option2, option3, option4, option5 each of type int. In the beginning, these columns have 0 as their value. How do I add 1 to any column, say option2? I mean do i retrieve the value of that column first, perform addition, and store back, or is there any auto increment function?

Answer 1

You could try a normal UPDATE, and just replace the column option in question.

UPDATE pollData SET option2 = option2 + 1

Answer 2

Like this you can try :

if(isset($option1)) {
       $optadd = " option1 = option1+1";
    } else if(isset($option2)) {
       $optadd = " option2 = option2+1";
    }

UPDATE `tablename` SET ".$optadd." WHERE fieldname = '1'