Need a SQL Query PRO!

[Wolverine77]

I want to add lets say 40 to an existing number in a colum.

Like i want to add 40 vote points to every player.

[latruwski]

try this:

Update player set votepoints=((select votepoints from player;)+40);

where player = tablename and votepoints = votepoints column
This should do it for all players if you want to do it for 1 player add a 'where' statement

grtz

[Dythzer]

That wont work, but you can simply do this:

UPDATE table SET column = column + 40 WHERE column = id;

Replace id with the player id

[Kalash47]

That wont work, but you can simply do this:

UPDATE table SET column = column + 40 WHERE column = id;

Replace id with the player id

Can be even simpler than that

UPDATE `table` SET `column`+='40' WHERE `column`='id';

[latruwski]

it should work the thing i said... maybe not perfectly right syntax but it should as it is exacly the same as what you do only you guys do it shorter
UPDATE `table` SET `column`+='40' WHERE `column`='id';

there is something cool I don't know how i didn't post that >< I learn java at school, we use that all the time xD