adding to numerical value of column

Question

Hi so I was wondering what the best way to add or subtract from a field in my table would be. The way I know it would work is if I query the value do the addition and then UPDATE the value.

I would rather include the addition as part of the update query like:

UPDATE users SET points = +10

Or something like that. Is it possible?

Paul · Accepted Answer · 2011-07-29 01:30:52Z

2

You just need to name the column on the right hand side of the = operator:

UPDATE `users` SET `points` = `points`+10

Since there is no WHERE clause this will give all users 10 more points then they currently have.

edited Jul 29, 2011 at 1:30

answered Jul 29, 2011 at 1:16

Paul

142k28 gold badges285 silver badges272 bronze badges

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

Comments

Oscar Gomez · Accepted Answer · 2011-07-29 01:17:19Z

2

You can just do this:

UPDATE users SET points = points + 10

answered Jul 29, 2011 at 1:17

Oscar Gomez

18.5k14 gold badges88 silver badges119 bronze badges

Collectives™ on Stack Overflow

adding to numerical value of column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related