Question on MySQL

[CyberClaus]

Hi, i come here today to ask ask something about MySQL.

So, my doubt is about calculations.

I have a table that inside as 2 rows, one row is MAX, the other Remain.

Ok, what i need is that the Remain row subtracts 1 from the MAX. So, if i have in row MAX 10

and in row REMAIN 10, when i click in the software it reduces the value of the row REMAIN to 9 and so on.

 

Im a little blocked there, a little help please.