How can I reduce 1 from a value in SQL?

[Fratini]

Hi!

I'm thinking of reduce 1 from a value in SQL. For example:

 

I have a value called 'zeny' from a table called 'debt', which has 300,000.

I want to reduce 1 from that value, which goes to 299,999.

 

How can I make that in a sample way?

 

Thank you for your time!

[Tokei]

You could use the following:

UPDATE `debt` SET `zeny` = `zeny` - 1 WHERE `zeny` > 0

[Fratini]

Thank you!