Subtracting 1 from fields.

[Namadoor]

What is the correct MySQL syntax for set the value in field x to 1 less than it currently is?

I currently have this:

UPDATE table
SET x = x - 1

But it doesn't work. What is the correct way to do this?

Thanks for your help.

[tsinka]

Hi,

this is exactly the way it should work.

What error do you get ? What type is the column of ?

Thomas