incrementing a table column's data by one || mySql

Question

iam having a table with columns like

id || counter

if i do something (some event) i want the counter's value(at a particular id) to increase by one , currently iam doing this :

    //get current value
    current_value = select counter from myTable where id='someValue'  

    // increase value
    current_value++   

   //update table with current value
    update myTable set counter=current_value where id='someValue';

currently iam running 2 queries for this, please suggest me some way do it in one step.

Joe Mastey · Accepted Answer · 2010-05-06 05:03:00Z

8

Just run the math in the database:

update myTable set counter = counter + 1 where id = 'someValue';

answered May 6, 2010 at 5:03

Joe Mastey

27.1k13 gold badges82 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

incrementing a table column's data by one || mySql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related