How to update a column adding 1 to the current value

Question

Hi guys, i can't do a relative simple update query in access or sql server. My simple task is: adding 1 to the current value of a column.

I'm using this syntax:

UPDATE MyTable SET ColumnA = ColumnA + 1 WHERE MyPrimaryKey= 100

But it does't work.

Someone can help me ?

Thanks bye!

Answer 1

Asked & answered before

Your query seems ok. Is there any error while trying to execute the query ?

Answer 2

i think you can use a variable here.

code should be more or less:

DECLARE @MyVariable int;
SET @MyVariable = SELECT ColumnA FROM tableA WHERE PK=100; 
SET @MyVariable = @MyVariable + 1; 
UPDATE tableA SET ColumnA = @MyVariable WHERE PK=100;

it's been some time i haven't write sql but it should be something like that.

Answer 3

Ok guys i've solved.. my error was this:

UPDATE myTable SET Column1=Column1+1 AND Column2=Column2+2

instead

UPDATE myTable SET Column1=Column1+1 , Column2=Column2+2

I've used AND instead ,

Bye and thanks to all helped me !

Bye